Forum Discussion
Solved
Preparation of .csv file with multiple unique IDs
I have two files - one for person and one for place. The Person file contains 45 Person IDs and the Place file contains 85 Place IDs. I want to be able to produce a single .csv file where each Perso...
Hi Karen,
If data is structured like this
you may use in F3
=OFFSET($B$2,INT((ROW()-ROW($D$2)-1)/COUNTA($D$3:$D$500))+1,0)
in G3
=OFFSET($D$2,MOD(ROW()-ROW($D$2)-1,COUNTA($D$3:$D$500))+1,0)
and drag that cells down till combinations end.
Same is in attached.
Hi Karen,
If data is structured like this
you may use in F3
=OFFSET($B$2,INT((ROW()-ROW($D$2)-1)/COUNTA($D$3:$D$500))+1,0)
in G3
=OFFSET($D$2,MOD(ROW()-ROW($D$2)-1,COUNTA($D$3:$D$500))+1,0)
and drag that cells down till combinations end.
Same is in attached.
This is great - thanks very much!
You are welcome
