Update table2 after updating first table1

[mshashmi]

Hi

I have two tables, table1 and table2.

Table2 is sorted form of table1. When I updated table1, the data in table2 remained the same. Is there any option to refresh data in table2 according to the new data in table1 or do I need to do sorting again in table2?

Thanks

[cs_skit · Accepted solution]

If you create table2 entirely in PowerQuery (aka "Query Editor") based off of table1 it will be recreated each time you refresh table1.