Converting/Exporting data from old table to new table

[kirkley08]

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!

 

[kirkley08]

It is required to select 7x6 cells (A5:G11) for AutoFill.

Hey, I tried this one and it works! at first I was wondering if there is any simpler way to just use raw data (the database) and export it directly to the new table model, but this method also saves a lot of time!

big thanks for @awoohaw and @fjns for helping me through this one!

 

[fjns]

Hi, I am very glad that the formulas work.
If I have enough knowledge, I am happy to help at any time.