I have a list that contains people's names in one column and their company's names in a second column. At the top of each column there is a label, i.e "Name" for column A, "Company" for column B.
The way a program I want to use works is to read data from a master list in one column, and it differentiates the type of data contained in the first column using second column, like this:
The ultimate goal is to have this data pulled automatically from an outside source, which is stored on one tab. There will then be another tab containing this master list, one column containing people's names and various company names, and a second column with the first column's data type (i.e 'Person' or 'Company', as pictured above) right next to it.
So far I have been able to populate individual columns in the second tab by using Sheet's "QUERY" function,
`QUERY('Importer'!A2:A)`
which allows the column to update very nicely every time the other tab is updated from the outside source, the problem is that because I don't know ahead of time how long the referenced column is going to be, I can't add a second 'QUERY' function to pull data from another column below it.
Any tips on how to solve this would be much appreciated. Thanks!