Hi everyone,

Running Excel 2010:

I have to transpose a single column report with 11 fields one on top of the other for each record to a single row with a column for each field.

E.G.

From:
[Column1]
[Field 1]
[Field 2]
[Field 3]
[Field 4]

To:
[Column 1][Column 2][Column 3][Column 4]
[Row 1]

Any thoughts how this can be done, as the transpose only allows me to copy one record at a time?

Many thanks in advance.