Transpose large data set

[jamezsez]

Hi All,

I am having much difficulty transposing a large data set. The result I am after seems simple but is proving to be somewhat difficult.

I have a list of the following data.

Account1

a

b

c

<tbody>
</tbody>

Account2

d

e

f

<tbody>
</tbody>

Account3

g

h

i

<tbody>
</tbody>

How I would like the data to be,

Account1	a	b	c
Account2	d	e	f
Account3	g	h	i

<tbody>
</tbody>

I know this can be done with a simple transpose formula/paste but my dataset is 47,000 rows long, so copying and pasting individually is not an option. I think VBA might be the way to go, but I havent got a clue where to even start.

Help!

Thank you.

 

[Special-K99]

This will transpose the data in column A in groups of 4 (Account number and following 3 rows)

in C1
=INDEX($A$1:$A$12,INT((ROW()-1)*4)+COLUMN()-2,1)

copy across to F1
now copy C1:F1 down as far as row 11,750
or until you get errors by which time the column A data will have expired