I have a table in this structure (from a SharePoint List):
I'd like to transform it (unpivot, pivot, etc.) to obtain this result (for example):
Basically, I'd like to group all the question columns, comments columns, points columns, and reason columns into their own respective columns with the corresponding rows.
Is there a way to transform my data to get that end result?
Go to Solution.
You will need to find the delimiter between Question 1 and Comments, Points, etc. For example, if you have Question 1: CommentsQuestion 1: PointsQuestion 1: Missed ReasonsIf you don't have that delimiter, you can use a conditional column to look for text that contains Missed Reasons, Point, Comments and use that to determine which part of the question it answers. Please see the attached file for reference. I will upload it under the signature.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.