Turn data

C

chad_needs_help

I have a list that is in Excel, but was sent to me without a header row.
Instead, Column A lists what data should be in the header, repeated for each
entry. Aside from the copy paste special, and transpose command, is there any
way that I can change the data to appear as in rows versus two columns?
 
O

Otto Moehrbach

If you exclude the transpose command, as you did, a VBA solution would be
required. But more detail about your data layout would be needed for
someone to come up with the VBA code you would need. If you wish, send me,
direct, your file, or a sample of it. Include in this file a small sample
of what you want the layout of the data to look like. My email address is
[email protected]. Remove "nop" from this address. HTH Otto
 
Top