Google Answers Logo
View Question
 
Q: Command for Microsoft Excel to rearrange a data series for plotting ( No Answer,   1 Comment )
Question  
Subject: Command for Microsoft Excel to rearrange a data series for plotting
Category: Computers
Asked by: ratilla-ga
List Price: $5.00
Posted: 07 Sep 2002 11:34 PDT
Expires: 07 Oct 2002 11:34 PDT
Question ID: 62621
Is there a Microsoft Excel command that rearranges a data or text
series?
For example if you have a text series:  flower, cow, jump,
pepsi,sandwich.
Rearrange or flip it to read -   sandwich, pepsi, jump, cow, flower.

I have a data series with 180 data points that need to be flipped from
left to right.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Command for Microsoft Excel to rearrange a data series for plotting
From: respree-ga on 07 Sep 2002 12:58 PDT
 
Step 1: On the last row of your data, number them 1 through "X"
sequentially, going from left to right.  If you use a formula to do
the numbering, make sure to convert to values.

Step 2: Sort Data.  Typically, you would sort by columns. However,
this time you want to sort by rows.

A.  Highlight your data including your newly added row in Step 1.
B.  On your menu, Select Data, Sort.
C.  Click on the Options button.
D.  Select the radio button "sort from left to right," then click
"OK."
E.  Change the "Sort by" dropdown selector to the row with your
numbers and click the radio button "Descending,"

Your data will now be flip flopped. =)

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy