Help with Converting rows of data to columns

[tbruce]

HI,

I can't seem to figure the best way to convert multiple rows of data into columns. I have a contact list saved in rows - each contact represents 6 rows then the next contact starts then there are three blank rows then the rest of the info. for that contact. I'm trying to place each row into a specific column. Here is some sample data:

John Doe
Architect
ABC Builders
Renton, Washington
jdoe@abcbuildings.com
422-123-1234
David Pierce



Construction
Pierce Construction
Seattle, Washington
dpierce@pierceconstruction.com
454-344-5555
Tony Demanto



Construction
Pierce Construction
Seattle, Washington
tdemanto@pierceconstruction.com
454-344-5551


I would like to set this up in columns - LAST NAME, FIRST NAME, Position, Company, City, State, Email Address, Contact Number. Any help would be much appreciated.

 

[tonyyy]

If you're comfortable with a vba solution, you might consider the scripts on this previous post...

Cheers,

tonyyy

 

[tbruce]

Is there a formula I can use instead?