Sort data in rows to column

  • Thread starter Thread starter Venice
  • Start date Start date
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.
 
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
Access Running Balance in Access 1
Multi-demensional frequency distribution 4
Sorting rows of 2 Seperate Columns Together 2
Column and Row mapping? 4
Column link 2
Copy paste data from a column to a row 0
sumif to work with times along a row 2

Back
Top