I need some help with an existing spreadsheet. I want to create a new one which will duplicate 2 rows based off of the data that resides in multiple rows. Here is a sample of what I need:
1st Row is the Header Row.
A1 = Company Name
B1 = Contact Name
C1 = ABC1
D1 = ABC2
E1 = ABC3
F1 = DEF1
G1 = DEF2
H1 = DEF3
I1 = GHI1
J1 = GHI2
K1 = GHI3
(etc..)
I need to consolidate all columns down to 5 (A,B,C,D,E) to get the following new spreadsheet result:
A1 = Company Name
B1 = Name
C1 = Code1
D1 = Code2
E1 = Code3
Example of Sample to Results needed:
SAMPLE data:
ABC Inc,John Doe,ABC1,ABC2,ABC3,DEF1,DEF2,DEF3,GHI1,GHI2,GHI3
XYZ LLC,Joe Smith,ABC1,ABC2,ABC3,DEF1,DEF2,DEF3,GHI1,GHI2,GHI3
etc...
RESULTING data:
ABC Inc, John Doe, ABC1, ABC2, ABC3
ABC Inc, John Doe, DEF1, DEF2, DEF3
ABC Inc, John Doe, GHI1, GHI2, GHI3
XYZ LLC, Joe Smith, ABC1, ABC2, ABC3
XYZ LLC, Joe Smith, DEF1, DEF2, DEF3
XYZ LLC, Joe Smith, GHI1, GHI2, GHI3
etc...
Please help me out. Thank you!!
1st Row is the Header Row.
A1 = Company Name
B1 = Contact Name
C1 = ABC1
D1 = ABC2
E1 = ABC3
F1 = DEF1
G1 = DEF2
H1 = DEF3
I1 = GHI1
J1 = GHI2
K1 = GHI3
(etc..)
I need to consolidate all columns down to 5 (A,B,C,D,E) to get the following new spreadsheet result:
A1 = Company Name
B1 = Name
C1 = Code1
D1 = Code2
E1 = Code3
Example of Sample to Results needed:
SAMPLE data:
ABC Inc,John Doe,ABC1,ABC2,ABC3,DEF1,DEF2,DEF3,GHI1,GHI2,GHI3
XYZ LLC,Joe Smith,ABC1,ABC2,ABC3,DEF1,DEF2,DEF3,GHI1,GHI2,GHI3
etc...
RESULTING data:
ABC Inc, John Doe, ABC1, ABC2, ABC3
ABC Inc, John Doe, DEF1, DEF2, DEF3
ABC Inc, John Doe, GHI1, GHI2, GHI3
XYZ LLC, Joe Smith, ABC1, ABC2, ABC3
XYZ LLC, Joe Smith, DEF1, DEF2, DEF3
XYZ LLC, Joe Smith, GHI1, GHI2, GHI3
etc...
Please help me out. Thank you!!