How to Turn Rows in One Column Into Field Headers.

[TwanD]

Hi everyone,

I'm trying to turn all my rows under F1 column into headers and having a hard time figuring out how to do so.

Original Data:

F1                             F2             F3               F4

Tax Owner               O1             O1              O2

Tax Code                 001            001             002

Entity Name             A                B                C

I want it to look like this:

Tax Owner              Tax Code             Entity Name

O1                           001                       A

O1                           001                       B

O2                           002                       C

I tried transposing and that doesn't seem to work. Any help would be greatly appreciated, thanks!

[ljpanetta]

Thank you so much! Really appreciate it.

[TNRazorbacker]

Thanks- very helpful