Transpose a list after population

**C90RanMan** · 10-27-2010, 03:57 PM

I would like to transpose a list to use as column headers once the list is self generated. Is this possible? I have included an example

**beaunydal** · 10-27-2010, 07:05 PM

Do you mean like this?

Please Login or Register  to view this content.

in J1 filled across as far as needed.

**DonkeyOte** · 10-28-2010, 03:46 AM

To be honest I think a lot of what you have (F:H) is unnecessary

Based on your requirements I would do the following:

Please Login or Register  to view this content.

At this point there is no need for any of the formula / values in F:H

**C90RanMan** · 10-29-2010, 02:59 PM

Thanks Don! If i am not mistaken i believe you helped in creating the formulas in "G" column. Thanks so much! The same six digit numbers are required in both column format on one tab . . . and as column headers in another for HLOOKUP purposes. I think this is what i need.

Thanks Again!