How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9659
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

running Excel on Mac OSX 10.5.8. I want to take data from on

Resolved Question:

running Excel on Mac OSX 10.5.8. I want to take data from on report where the client's names are XXXXX XXXXX Y axis (column A) and their data categories are on the x axis (columns with headers on row 1 ) and put them into a report where this orientation is switched. That is each client's data appears in a column below the name, with the data categories listed in Column A. Is there some way that I can rotate the spread sheet 90 degrees?
Submitted: 4 years ago.
Category: Mac
Expert:  John D replied 4 years ago.

Hi,

 

I will be happy to switch the axis for you and show you how it's done if you can send me the file. Do you have the file available that you could upload?

 

Customer: replied 4 years ago.
yes I can upload an example file. don't see how to attach it to this reply ,but I can certainly do it if you tell me how..e
Expert:  John D replied 4 years ago.

Sure, go to www.wikisend.com and upload the file there. You will then get a page that has the File ID and Download Link. Copy either the File ID or the Download Link and come back here and paste it in your reply.

 

 

Customer: replied 4 years ago.
http://wikisend.com/download/486554/Workbook3.xlsx
Download link
Expert:  John D replied 4 years ago.

Got it!

 

I don't see an existing chart to switch the axes of, not do I see names in column A.

 

Which specific columns (x and y) need to be plotted. Maybe you need to rephrase the original question so it applies to the file that you sent me

 

 

Customer: replied 4 years ago.
sorry to be confusing. When I look at workbook 3 (the example that I sent) Cell 1A says "res" and the rest of the cells in that column say "Red Bluff". Cell 1B says "month", 1C says "day" etc. I guess what I need to do is to just rotate the chart 90 degrees so that the "res", "month", "day", etc are in the column under A and the "Red Bluff"'s appear in cells 1B, 1C, 1D, 1E, etc horizonatlly. Then the row 2A,B,C,D etc would have the month (August). Row 3 the days, row 4 the community, etc
Does that make more sense?
Customer: replied 4 years ago.
Somebody still working on this? Haven't heard anything for a while....e
Expert:  John D replied 4 years ago.

Sorry had to step out for a while

 

Ok here you go

 

FILE

 

I have converted the first 12 columns of Sheet1 (i.e. columns A thru L) into rows on Sheet2 (rows 1 thru 12). If you need me to do the rest of the columns please let me know

 

Hope this is ok. Please feel free to reply if you need further clarification or click Accept if this answers your question fully.

 



Edited by John D on 10/13/2010 at 2:53 AM EST
Customer: replied 4 years ago.
That is great and exactly what I wanted to do. But how did you do it. I have a ton of these sheets that I need to convert. This was just a small example.
Expert:  John D replied 4 years ago.

Glad this was what you wanted

 

Ok you are going to have to do it one column at time. If that's ok I will show you how you can do that in a few steps

 

 

Customer: replied 4 years ago.
Sorry , fell asleep...if I can do it one column at a time that is way better than one cell at a time. Please show me how to do it! thanks this is great! e
Expert:  John D replied 4 years ago.

Ok, here is a neat way to copy columns into rows (or vise versa)

 

1- select the range that you want to copy in that column (e.g. A1:A23), and copy it

2- select the first cell in the row that you want to paste it in horizontally

3- from the Edit menu select Paste Special

4- In the Paste Special dialog box, check the box next to Transpose and click OK

 

Voila!, data pasted.

 

Hope this helps. Please feel free to reply if you need further clarification or click Accept if this answers your question (that is the only way I get credit for helping)

 

 

 

John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9659
Experience: Worked on Macs and PC's for 20+ years.
John D and 5 other Mac Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
< Last | Next >
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
 
 
 

Meet The Experts:

 
 
 
  • Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
< Last | Next >
  • http://ww2.justanswer.com/uploads/macthelife/2009-10-20_1899_mikesebaharsquare64.jpg Mike's Avatar

    Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
  • http://ww2.justanswer.com/uploads/AS/ashiknasameen/2012-5-15_141836_final2.64x64.jpg Ashik's Avatar

    Ashik

    Mac Helper

    Satisfied Customers:

    5282
    7+ Years of Experience in troubleshooting Macs, iPhone, iPad, iPod etc
  • http://ww2.justanswer.com/uploads/DP/dpean/2012-6-6_172828_avatorme1.64x64.JPG Daniel's Avatar

    Daniel

    Mac Genius

    Satisfied Customers:

    4670
    Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.
  • http://ww2.justanswer.com/uploads/VI/vinodvmenon2005/1.64x64.jpg Vinod Menon's Avatar

    Vinod Menon

    Support Specialist

    Satisfied Customers:

    2068
    worked as a Tech support Associate for Apple products
  • http://ww2.justanswer.com/uploads/BE/beboo/2011-1-14_201648_n5063313142021801763.64x64.jpg Brandon M.'s Avatar

    Brandon M.

    Mac Support Specialist

    Satisfied Customers:

    1501
    10+ Years Mac Support as contractor and currently an IT Manager for law firm
  • http://ww2.justanswer.com/uploads/MA/MacDruid/IMG_0232.64x64.JPG John T. F.'s Avatar

    John T. F.

    Mac Druid

    Satisfied Customers:

    1408
    20+ years in the computer/Mac industry
  • http://ww2.justanswer.com/uploads/MA/MacHelpdesk/1d2d506.64x64.jpg David's Avatar

    David

    Mac Support Specialist

    Satisfied Customers:

    1236
    BSc, H.Dip, Apple Certified
 
 
 
Chat Now With A Mac Support Specialist
John D
John D
118 Satisfied Customers
Worked on Macs and PC's for 20+ years.