Does anyone have an easy way to select rows but show them transposed?

eg
name code zip
aa 432 03744
bb 343 94342

to show as
aa
432
03744

bb
343
94342


Thanks in advance,
Nirasha