Excel 2007 : Copy and Pasting multiple times

**Ray789** · 05-05-2010, 07:01 AM

Hi,

I have one column with unique values:

Column A
Audi056
BMW45
Nissan34

Alongside the above In Column B through to AO I have multiple data:

Column A Column B Column C Column D....
Audi056 Mirror Tyres
BMW45 Wheel Mirrors
Nissan34 Tyres Seat Gear

I want to be able to have:
Column A with Column B valies beside it (Column A is 10k rows long)
Column A with Column C values beside (Now in Column B)

i.e.
Column A Column B
Audi56 Mirror
BMW45 Wheel
Nissan34 Tyres
Audi56 Tyres
BMW45 Mirrors
Nissan34 Seat
Audi56
BMW45
Nissan34 Gear

I could do this with copy and paste but it would take me hours. Wondering if there is an automated way.

**JBeaucaire** · 05-05-2010, 11:03 AM

This will do it. It will only copy down the cells with data in them:

Please Login or Register  to view this content.

**Ray789** · 05-05-2010, 01:05 PM

This is the Output I get:

Column A Column B
Audi56 Mirror
Audi56 Mirror
Audi56 Tyres
BMW45 Wheels
BMW45 Wheels
BMW45 Mirrors
Nissan34 Tyres
Nissan34 Tyres
Nissan34 Seat
Nissan34 Gears

Seems like its duplicating the information in certain instances i.e.Mirrors, Wheels

Can you assist?

**JBeaucaire** · 05-05-2010, 02:38 PM

Sure, you're testing on specific data, so let's see your workbook.

**JBeaucaire** · 05-05-2010, 02:40 PM

NVM, just change the 2 to a 3...we duplicated the first column of data when we didn't need to. I edited the original code above.

A sample file and the code is posted here for testing. (it's in Part 1).