finnstone
asked on
multiple columns far out to BG need to transpose
so i have a list of names in column A
in columns B-BG i have all the corresponding companies for these people.
I need to basically make a new 1:1 relationship for each person and each company. so for any one person, you would have this in column A, B...
PERSONA, COMPANY1
PERSONA, COMPANY2
PERSONA, COMPANY3
the other wrinkle
there are 35k people....each one has a different number of company affiliations , for example
row 1 PERSONA COMPANY1 COMPANY2 COMPANY3 COMPANY4 COMPANY5 COMPANY6
row 2 PERSONB COMPANY1 COMPANY2
row 3 PERSONC COMPANY1 COMPANY2 COMPANY3
in columns B-BG i have all the corresponding companies for these people.
I need to basically make a new 1:1 relationship for each person and each company. so for any one person, you would have this in column A, B...
PERSONA, COMPANY1
PERSONA, COMPANY2
PERSONA, COMPANY3
the other wrinkle
there are 35k people....each one has a different number of company affiliations , for example
row 1 PERSONA COMPANY1 COMPANY2 COMPANY3 COMPANY4 COMPANY5 COMPANY6
row 2 PERSONB COMPANY1 COMPANY2
row 3 PERSONC COMPANY1 COMPANY2 COMPANY3
ASKER
yes probably cleaner that way.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wow thatts super cool.
thank you
thank you
ASKER
cool macro
Welcome, glad that was useful.
~bp
~bp
~bp