Forum Discussion
Getting data in same row if conditions are met
mrstefan If you've never worked with PQ before, it's going to need a bit more than "little explaining". but the basic steps are to flatten the data (i.e., unpivot) and then Group and Split. It's not difficult but not easy to explain. Then perhaps Patrick2788 's formula-based solution is more suitable for you, though don't give up on PQ. Learn more about it here:
https://exceloffthegrid.com/power-query-introduction/
Yes this is how I imagined a solution! Can you explain it a little more?
mrstefan If you've never worked with PQ before, it's going to need a bit more than "little explaining". but the basic steps are to flatten the data (i.e., unpivot) and then Group and Split. It's not difficult but not easy to explain. Then perhaps Patrick2788 's formula-based solution is more suitable for you, though don't give up on PQ. Learn more about it here:
https://exceloffthegrid.com/power-query-introduction/
Riny_van_Eekelen Thanks for your help! I'm gonna study and practice this. Great help!