Please describe the next step and the end result. Transposing to wide format just for the sake of a merge operation might not be the best way to do it. Having data stored in a long format makes it's easier to query, maintain and build dynamic reports on top of. So without knowing the end result I would even suggest that you transpose score to rows... ... View more