Solved

excel question

Posted on 2013-06-18
248 Views
I have a 1 column Excel file with logical groupings of 5 records per group.  I want to "rotate" the data, 5 records at a time, and end up with 5 column Excel file.

If there an easy Excel way to do this?   I think SQL has a way to rotate data.
0
Question by:HLRosenberger

LVL 43

Accepted Solution

Saqib Husain, Syed earned 500 total points
If your data starts in cell A1 then enter this formula in C1

=INDEX(\$A:\$A,ROW(\$A\$1)-1+COLUMN()-COLUMN(\$C\$1)+1+5*(ROW()-ROW(\$C\$1)),1)

and copy it down and across
0

LVL 24

Expert Comment

If the data is in a data table you can use a CROSSTAB query to restructure your result.
0

LVL 1

Author Closing Comment

thanks
0

Featured Post

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…