Re-arrangement of table
Posted by philipjsmith on January 04, 2002 1:52 PM
On sheet 1 of a workbook I have a row with 12 headed columns. Up to the next 30 rows show 12 details of each of 30 items.Column 1 is used to number the items.
I want sheet 2 to show the same information but with the details shown in 3 rows of 4 details with the labels over each details. i.e. each item would require 6 rows.30 items would require 80 rows. On sheet 1, 30 items would take up 30 + 1 = 31 rows.
Is there a way of doing this for 1 to 30 items using formulae/or any other way?
Any help would be appreciated.