SQLTeam.com | Weblogs | Forums

Transposing data


#1

I have the following data in a table as follows:

How can I transpose the rows into columns so that it reads as follows:


#2

Would you please repost your input data, not as an image but as SQL:

CREATE TABLE foo (...)
INSERT INTO foo(...) VALUES
(...row1...),
(...row2...),
etc.