Sort data in rows to column

V

Venice

I would need to re-arrange the format of the data. My current data is:
In row 1, every 3 columns has headers Opening, Spent, End balance (ie A1 is
Opening, B1 is Spent, C1 is End bal), the same Opening, Spent, End balance
repeats in columns D to F, G to I, so on). The data (of numbres) is at Row 2.

My intention is to have i column for Opening, 1 for Spent and 1 for End
balance. Hence, I can do pivot from the new format. How can I do that without
copying each 3 columns one by one to the new format. Any other excel
functions can help me to rearrange quicker. Thanks.
 
J

Jacob Skaria

In cell A3 apply this formula and copy across to B3,C3. once done copy the
formulas down as required...

=INDEX($2:$2,ROW(A1)*3+COLUMN(A1))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header in row to column 1
Excel 2003 1
Subtotal percents in pivot table 1
Find & Replace one cell w/another cell unequal occurrences 3
monthly opening and closing balance in pivot table 4
Look Up Help Needed 3
sumif to work with times along a row 2
To find the cumilative balance 1

Top