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).

"Don D." wrote:
>
> 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
>
> --
> Don D.
> ------------------------------------------------------------------------
> Don D.'s Profile: http://www.excelforum.com/member.php...o&userid=30195
> View this thread: http://www.excelforum.com/showthread...hreadid=498806

--

Dave Peterson