Forum Discussion
Solved
Getting data in same row if conditions are met
Hi, I hope someone can send me in the right direction. This dataset contains the answers to a form with two answerfields. The 'pseudo_id' is the unique identificationnumber of the subject. '...
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/
If you have 365, you could do a bit of stacking with a formula:
=LET(header,EXPAND(D1:H1,1,8,""),ID_Start,D2:E7,data,F2:H7,VSTACK(header,HSTACK(UNIQUE(ID_Start),WRAPROWS(TOCOL(data),6))))
- Great help! I will try this too! Thanks!
- You're welcome. Glad it all worked out for you.
