I need to pull multiple cells of information into a single row, multi column spreadsheet. I basically need to pull all of the URLs that are associated with a single number into multiple columns in the same row.
For example, I have item 123. For that Item, on another spreadsheet, I have 10 different URLS associated with that item - URL1_123, URL2_123. etc, The URLs all contain the number of the item. But since there are multiple URLs, I am not sure how to pull all of them, I can only get one URL to pull in.
Solved by I. J. in 28 mins