I have data in rows that I would rather have it viewed in the columns section:

example:

a b c
1 x y z
2 x y z
3 x y z

but i want it to be

a b c
1 x x x
2 y y y
3 z z z

thanks