Sorting data in the sheet

[gesaugen]

I'm trying to sort data from online contacts book. Problem is that after importing data, some imputs have two or three rows because of additional phone or telefax number and those rows are written one under another. Other problem is that another column with the address is after import used for both address and workplace name. Looks like this (... are blanks):
Col1.../ Col2..../ Col3..../
Name1/ Phone1/ workplace1
Name2/ Phone1/ Workplace2
........./ Phone2/ Address

And I would like it to be:
Col1.../ Col2..../ Col3........./ Col4...../ Col5...../
Name1/ Phone1/ workplace1/.........../.........../
Name2/ Phone1/ workplace2/ Phone2/ Address/

[dflak]

Attach a sample workbook so we can better visualize the data. Thanks.

[GeoffW283]

some imputs have two or three rows

Your desired result does not specify the column layout where there are three rows worth of data for a given name.

[GeoffW283]

Here's a VBA solution.

Assumes source data is in cols A:C starting at A1

Execute the "rearrange" macro.

The re-arranged data starts at E1

See the attached workbook

Here's the VBA:

Please Login or Register  to view this content.