Column to Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don D. - 06 Jan 2006 18:39 GMT

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

Signature

Don D.

Reply to this Message

Dave Peterson - 06 Jan 2006 20:25 GMT

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

> I want to convert my data from one column into rows.
> I have my data set up now as follows:
[quoted text clipped - 31 lines]
> Don D.'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30195
> View this thread: http://www.excelforum.com/showthread.php?threadid=498806

Signature

Dave Peterson

Reply to this Message