Link to home
Start Free TrialLog in
Avatar of finnstone
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
Avatar of Bill Prew
Bill Prew

So you want the results on a new sheet?

~bp
Avatar of finnstone

ASKER

yes probably cleaner that way.
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
wow thatts super cool.

thank you
cool macro
Welcome, glad that was useful.

~bp