Log In
Register
Home
August 21, 2019
Offline
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
See Answer
July 16, 2010
Offline
Hi Chris,
You can extract the questions and number them in a separate query before merging them back to the original query where you do the rest of your cleaning and transforming. See attached.
Mynda
Answers Post
Power Query
Power Pivot
Power BI
October 17, 2018
Offline
Mynda,
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.
Steve
July 16, 2010
Offline
Hi Steve,
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.
Mynda
1 Guest(s)
