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/