Computing.Net > Forums > Windows 95/98 > How do I reverse the X- and Y- axis in an Excel Worksheet?

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 do I reverse the X- and Y- axis in an Excel Worksheet?

Reply to Message Icon

Name: Tony
Date: April 25, 2000 at 03:13:59 Pacific
Comment:

Hi,
I am in a "spreadsheet hell" at the moment.
I was sent a spreadsheet with all of the different field headings down the left side (in column A they are repeating every 10 rows) and the corresponding data in comumn B. I really need to swop this so that there is one row along the top of ten column headings, and then the 2000 rows of data under the corresponding headings. Anyone out there PLEASE know of an automatic way to do this? Even Access needs the data in this format (which is where I want the data eventually).
Thanks in advance.
Tony



Sponsored Link
Ads by Google

Response Number 1
Name: Viv
Date: April 25, 2000 at 06:57:05 Pacific
Reply:

Do a "inverting (transposing) rows and columns" in Excel. May be that's what you are looking for.

Repost and let me know


0

Response Number 2
Name: Tony
Date: April 25, 2000 at 08:08:03 Pacific
Reply:

Thanks Viv, I will try that (via the help in Excel) and let you know.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows 95/98 Forum Home


Sponsored links

Ads by Google


Results for: How do I reverse the X- and Y- axis in an Excel Worksheet?

How do I check my processor and MB to see if they still work?? www.computing.net/answers/windows-95/how-do-i-check-my-processor-and-mb-to-see-if-they-still-work/59882.html

How Do I Remove the Arrow from a Shortcut Icon? www.computing.net/answers/windows-95/how-do-i-remove-the-arrow-from-a-shortcut-icon/51283.html

archivse in icq . How do i empty the waste basket www.computing.net/answers/windows-95/archivse-in-icq-how-do-i-empty-the-waste-basket-/20924.html