Excel: Need to move information from hundreds of rows in Column A into Columns

[johnson.patrickd]

I have information in Excel that is in hundreds of rows in column A. I need to organize and move the information in column A into Rows through Columns c through E according to Name, Courthouse, Address.


Currently it looks like this:

COLUMN A COLUMN B Name Courthouse Address Phone Number

John Adams 1

Courthouse1 2

Main St 3

Phone Number 4


Jane Monroe 1

Courthouse 2 2

Grant ST 3

Phone Number 4


I need it to look like this for each entry on a single row matching up with the topics:

Name Courthouse Address 1 Phone Number

John

Jane


I need the information to go across for each entry for mail merge purposes. I tried following some directions I found on a somewhat similar question. That is why in column B I marked each name with a 1, courthouse with a 2. etc.


Thanks

 

[jason]

it may be helpful to upload a sample.


at first, i was thinking about copy/cut and using the "transpose" optoin under Paste Special...... but without seeing it, im not sure if that would give you what youre looking for.

 

[nishant859@yahoo.co.in]

Use below mention formula in mentioned cells & Drag until you cover your entire data in the format you want


here, i assumed blank row in between ((Phone Number 4)) & ((Jane Monroe 1))


In C2 :- INDEX($A$1:$A$36000,ROW()+(4*(ROW()-2)),1)

In D2 :- INDEX($A$1:$A$36000,ROW()+(4*(ROW()-2))+1,1)

In E2 :- INDEX($A$1:$A$36000,ROW()+(4*(ROW()-2))+2,1)

In F2 :- INDEX($A$1:$A$36000,ROW()+(4*(ROW()-2))+3,1)

else, if we don't have row space than use

In C2 :- INDEX($A$1:$A$36000,ROW()+(3*(ROW()-2)),1)

In D2 :- INDEX($A$1:$A$36000,ROW()+(3*(ROW()-2))+1,1)

In E2 :- INDEX($A$1:$A$36000,ROW()+(3*(ROW()-2))+2,1)

In F2 :- INDEX($A$1:$A$36000,ROW()+(3*(ROW()-2))+3,1)