R
Raph
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.
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.