Transpose data

[Florinnn]

Hi everyone.

First of all, thanks in advance for the help.

I have a set of data with about 80 rows and 20 columns (see example).
In each of the cells(other than the headers) there is one value only (from a set of totaly 4 or 5 different values possible).

I want to transpose the data, the way you see it in the example sheet which I have attached. Do you think it's doable? Can this be done with a pivot table?

Thank you.

Florin