I am looking to transpose a row into multiple columns. I have a member's data who might be associated with multiple labs for that one member. Instead of having multiple records for that member, I would like to have one record per member with multiple rows for the lab data. any help would be greatly appreciated!!

You bet. This is the result for a member. He/She has multiple records because of the dbo.RptLabMembers.LabTypeId. I would like one record per member. so basically pivoting out the labtypeID believe is the solution, but was unable to do that. Sorry for the messy data, but it is the last field in each row (6,7,8,19)