Help with data reformat

[Zealand89]

Hello.

I have 1100 part numbers in column A, against that in Column B we have some data that has been entered on separate lines within the cell

Part Number	Origial
Part 1	Audi (A3 A4) BMW (5 6 7) Volvo (V50 S40) Mercedes (C S) BMW (5 6 7) Volvo (V50 S40)
Part 2	Mercedes (C S) BMW (5 6 7) Citroen (C4 C6 C8) Volvo (V50 S40)

I want to re format to put into a database.

How could i take the above data and change it to become the below? So that each make / model gets allocated to a new row against the part.

Part 1	Audi (A3 A4) BMW (5 6 7) Volvo (V50 S40) Mercedes (C S) BMW (5 6 7) Volvo (V50 S40)	Audi A3
Part 1		Audi A4
Part 1		BMW 5
Part 1		BMW 6
Part 1		BMW 7
Part 1		Volvo V50
Part 1		Volvo S40

Thanks,

 

[kweaver]

Why aren't the two Merc types also shown for Part 1? Then, what happens with Part 2?