Split Master Table based into multiple tables based on word in second column

[Anonymous]

Hi Experts

Is it possible to split a master table with 10,00 rows into mulitple tables in Power Query, Based a word in that appears in a column 2 is Adjust. Basically scan down the tables and find that teh word Adjust and split that  table into serveral tables.

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You can copy multiple tables, and then filter data based on the word in second column

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , You can create a flag and then filter it. Create multiple copies and filter based on the flag.