Re-structuring contact lists

R

ryan.marples

So I've got a long Excel workbook in the following structure:

AAA Widgets,John Smith,555-555-5555,Bob Smith,666-666-6666,Bill
Smith,777-777-7777
BBB Widgets,Jane Doe,111-111-1111,John Doe,222-222-2222,Mary
Doe,333-333-3333
CCC Widgets,Jim Bo,444-444-4444,John Bo,888-888-8888,Chuck
Bo,999-999-9999

I would like to put this in the following format:

AAA Widgets,John Smith,555-555-5555
AAA Widgets,Bob Smith,666-666-6666
AAA Widgets,Bill Smith,777-777-7777
BBB Widgets,Jane Doe,111-111-1111
BBB Widgets,John Doe,222-222-2222
BBB Widgets,Mary Doe,333-333-3333
CCC Widgets,Jim Bo,444-444-4444
CCC Widgets,John Bo,888-888-8888
CCC Widgets,Chuck Bo,999-999-9999

I have traditionally imported the Excel file into a database and wrote
some queries that re-mapped the data but I would love to be able to do
this in Excel itself. Any ideas? I have played around with the OFFSET
function but haven't been able to come up with anything quite yet...

Any ideas much appreciated!

R
 
R

Ryan M

Thank you very much Max for the ideas and the nice sample workbook. I
adapted those formulas and got it working. Much appreciated! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search by product & alsoshow other products purchased by same cust 2
use list of criteria in filter 0
Transpose Issue from Columns to Rows... 4
Repeat Values in Column A, Break and Sum 2
Combine two sets of overlapping Date/Time data into 3 columns. 3
index and matching with string search! 4
paste special macro 5
OFFSET equation not working 3

Top