Column to Rows

[Don D.]

I want to convert my data from one column into rows.
I have my data set up now as follows:

John Smith
$3200
555 Main St.
95111

Jane Jones
$5500
345 Happy Dr.
93434

Jack Clark
$2300
354 Oak Pl.
95343

I want it to be displayed into 4 separate columns as follows:

John Smith $3200 555 Main St. 95111
Jane Jones $5500 345 Happy Dr. 93434
Jack Clark $2300 354 Oak Pl. 95343


Please advise,

thanks,

Don

 

[Dave Peterson]

If you always have groups of 4 with a gap between and it starts in A1, then put
this in B1:

=INDEX($A:$A,(5*(ROW()-1))+COLUMN()-1)

And drag across to E1

Then select A1:E1
and drag down until you run out of data (you'll see a bunch of 0's).