B
B~O~B
I am using Excel 2003 and have what i call my prim col (A) and my sec
col (B:BZ).
A B C D ...
B001 X002 Y100
B002 X002 Y110 XX04
What I need to do is copy the prim to a new sheet in col "a" for each
of the sec data. NOTE: each Prim col can have 1 to 70+ related sec
col.
Should look like this:
B001 X002
B001 Y100
B002 X002
B002 Y110
B002 XX04
....
Can any one help?
col (B:BZ).
A B C D ...
B001 X002 Y100
B002 X002 Y110 XX04
What I need to do is copy the prim to a new sheet in col "a" for each
of the sec data. NOTE: each Prim col can have 1 to 70+ related sec
col.
Should look like this:
B001 X002
B001 Y100
B002 X002
B002 Y110
B002 XX04
....
Can any one help?