I have the following data in a table as follows:
How can I transpose the rows into columns so that it reads as follows:
Would you please repost your input data, not as an image but as SQL:
CREATE TABLE foo (...)
INSERT INTO foo(...) VALUES
(...row1...),
(...row2...),
etc.