August 21, 2019
Hi Power Query Guru,
I was trying to transform a set of un-structured questionnaires using Power Query, any good suggestion on transforming with lesser steps ?
Thank you in advanced
Note:- my desire result in tab 2
July 16, 2010
October 17, 2018
I was following along your solution trying to duplicate your PQ solution myself, and a couple of questions as to how you got to your solution popped up for me as I am midway thru your PQ course.
1. I noticed that in my Excel 365 I could only have either your PQ editor open or my version of PQ editor open. No concurrent PQ Editors were available to me. Is that just the way it is?
2. It is obvious your experience/knowledge indicated the need to duplicate the initial query. What may have triggered that thought process? I ask this so that I can better see when to do this in my own potential queries.
3. In the PQ course you indicate that you usually like to merge queries as new. Was there any special reason in this instance that you didn't merge as new?
Your site is extremely helpful.
July 16, 2010
Great questions. Answers below:
1. That's just the way it is. Once the editor window is open you can't even work in the Excel worksheet. It's very annoying, but I'm not aware of any plans to change it despite our complaints to Microsoft.
2. I created a separate query because I needed to number the items for the question names but there were blank rows which I needed to remove for this purpose, but also needed to retain that detail for the end result of the query. It was easiest to create two queries, one with blank rows removed and one with them retained.
3. It was a simple query so I just merged them. For beginners I recommend merge queries as new because it's easier to follow.