Forum Discussion

donpep0's avatar
donpep0
Frequent Visitor
4 years ago

Split table into multiple tables based on value of 2 columns

Hi! I'm working with Power Query and I need to split the main table into multiple tables. It's possible to split a table into multiple tables based on 2 value conditions?   I have the below table ...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi donpep0 ,

 

Looks like an XY Problem to me.

Can you give details on what exactly your end-goal is please? Splitting tables into pieces like this is highly irregular, so I'm thinking there's probably a faster/easier way to get to your end-goal than this.

 

Pete