How do I rotate data in a spreadsheet so that rows become columns?
Once again I find myself needing to do something in Excel that I know SHOULD
be possible, but have never figured out HOW. I've captured meaningful data as
text and pasted it in Excel. First row is "name", second row is "address",
third row is "city", fourth row is blank and then the fifth row starts with
the next record's "name". My need and desire is to rotate this data so that
column one is "name", column two is "address", column three is "city" and
each row is a separate record.
Assistance please!
Thanks!!
|