Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
How to swap column and row headers?
Name: MrBedo Date: August 20, 2004 at 01:07:14 Pacific OS: Windows XP CPU/Ram: P4 256
Comment:
I currently have an excel sheet with what should be the column names actually down the left hand side so that they are row names (if that makes sense!). For example it currently looks like this: Column1 Column2 Column3 TeamName Rangers Wanderers YourName Bob James Goalie Peter Joe Striker1 Jeff Mike Striker2 Dave Jon
All I want to be able to do is swap them so that Column1 becomes the row headers and the actual data falls into the respective column. So it winds up looking like this:
Column1 Column2 Column3 Column4 TeamName YourName Goalie Striker1 Rangers Bob Peter Jeff Wanderers James Joe Mike
Summary: Thanks, I did see that post, unfortunately I can't figure out how to modify it to look at 2nd column without deleting what it found in the first one. Any help would be appreciated. Thanks ...
Summary: Hi Bryan, Well the ignorance is on my part totally. Did I fail to mention novice? :-) I do know how to download music and save it to my play list and burn my music to a CD using Windows Media Player 9...
Summary: (several machines access the same data which is why there are 2 versions of software) I work in an office where we have a lot of contacts within outlook. We also have a seperate access database storin...
0 
