copying multiple rows to columns

[calvin]

i need to copy every 4th row and put it in its own column while using the
first row in each new column as its name. eg.

pepole fruit
boy apple
girl pear
man mango
fruit
apple
pear
mango

 

[smartin]

i need to copy every 4th row and put it in its own column while using the
first row in each new column as its name. eg.

pepole fruit
boy apple
girl pear
man mango
fruit
apple
pear
mango

This might work for you: If the "master list" is in A1:Ax and you want
to bump 4 rows at a time into B1:B4, C1:C4, etc., try one of these
formulae in B1:B4 and fill right as needed:

=INDEX($A$1:$A$x,4*(COLUMN()-1)+ROW()) [fix $A$x to suit your range]

=OFFSET($A$1,4*(COLUMN()-1)+ROW()-1,) [no adjustment required]