Forum Discussion

festos67's avatar
festos67
Copper Contributor
Apr 07, 2021

Autofill empty table with data from database (csv)

Hello in the same workbook i have an empty table on one sheet and a database on the other sheet , the data came from a csv file. I need to find a way to autofil the empty table with the data from the database .The two table have differents header . How can  I do that ? Is there a way that use powerquery?

Thanks

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    festos67 

    As variant you may ignore empty table - Power Query csv file, transform as needed and return table to the sheet (instead of empty one).

Resources