Yes, that is exactly what I need / want. I mean, there will not be 2 million different LabNames, but one userID could have 3, and another have 30 - 40. Not a huge amount.

My other question is, does each UserID have to have the same number? I would be happy if the user that has only 3, compared to one that has 20, will have null values in the missing columns.

Thanks

Andrew SQLDBA