hef

=INDIRECT("A"&(COLUMN()+(ROW()-2)*3))

Enter this is in B2 then drag across to D2 then drag down to B28:D28

When happy with the results, copy all and paste specialvalues. Delete
original column A if wish.

Gord Dibben XL2002

On Thu, 6 Nov 2003 17:38:11 -0500, hef
wrote:


I need to take a column that goes from a2:a81 and turn it into 27 rows
ie:
a
b
c
d
e
f

needs to be
a b c
d e f

etc...


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/