Ive got a list of URLS in a google sheet.
charlie.com | apple | alpha.com | orange | beta.com | banana |
Ive got another list of data as a CSV (this could be imported into google sheets if it made the workflow easier) this data is as follows :
charlie.com | one alpha.com | three beta.com | seven
(note the URLS are the same, but the other data is different, the row order based upon the URLS is different also.
I want to combine these two sets of data so i get :
charlie.com | one | apple alpha.com | three | orange beta.com | seven | banana
(so that all the data is correctly aligned using the URLS as the key value.
How can i do this ?
So far from doing some research on Google, ive been looking at a 3rd party paid plugin (HERE) from that would enable me to do this, i feel its something that a spreadsheet would have input as a native function / workflow, but i cant seem to find the right search term for it when researching.