Hi everyone,
I'm trying to convert/export the data from my "Database" to the new excel table (different table format).
Other than using "lookup" formula, is there any other way to convert/export it faster? if the entry is 500 or 1000s, it will be time consuming to add the boxes in new table and applying the lookup formula.
Here attached the screenshot of my database and new table. Thanks!
I'm trying to convert/export the data from my "Database" to the new excel table (different table format).
Other than using "lookup" formula, is there any other way to convert/export it faster? if the entry is 500 or 1000s, it will be time consuming to add the boxes in new table and applying the lookup formula.
Here attached the screenshot of my database and new table. Thanks!