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
. Remove "nop" from this address. HTH Otto
"chad_needs_help" wrote in
message ...
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?