Copying and Arraying
 

Two sheets on one file.

First sheet(hidden columns) Second Sheet
AAAA 1
BBBB 2
CCCC 3
DDDD 4

Need to combine to first Worksheet to look like this(The way I'm doing it
now):

Copy ROW A info.
Grab 4 rows, right click - insert copied cells. I get:

AAAA
AAAA
AAAA
AAAA

I then need to stick in 1 2 3 4 in a column

A 1AA
A 2AA
A 3AA
A 4AA

AAAA---I then can delete this and redo process
BBBB
CCCC
DDDD


For example...
The letters represent Audi A4 / A6 / S4 / A8
The numbers represent ABS / Sunroof / heated seats / manual

Then I'm putting all four options down one column for each car model.

Tried to example the best I could and there has to be a better way. I have
like 75 options and 100 models, for a different industry of course.

Any help will be greatly appreciated.