Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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.

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

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

     

     

     

    Best Regards,
    Community Support Team _ Eason

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi, Anonymous 

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

     

     

     

    Best Regards,
    Community Support Team _ Eason