Example:

A B C D E F
1 green brown red yellow
2 green
3 brown
4 red
5 yellow
6
7

select A2:A5

type =transpose(b1:e1) and hit shift-control-enter (it's an array
formula)

That will arrange the horizontal numbers verticlly.

Then copy and edit--paste special--values to your new location

Hans