Nov 08 2021 04:01 AM
Hi,
As per the attached file, is it possible to get the output which is on the right side of the sheet. Left side one is the actual raw data.
Nov 08 2021 04:17 AM
@ParasUdani Perhaps by splitting up the query in three separate parts. See attached.
Nov 08 2021 04:21 AM - edited Nov 08 2021 04:23 AM
What if the category column is dynamic and it may have 15-20 categories. So this would become very much manual right ? (Currently for demo purpose - I just kept 3 categories). So is there a way in power query that it would identify unique Category and post which gives desired output. (horizontally left to right )??
Nov 08 2021 04:52 AM
@ParasUdani It's actually rather odd that you want to use PQ to go from nicely structured "raw" data to unstructured "final" data. One would usually go the other way around. Can't really think of a quick solution. Perhaps someone else.
Nov 08 2021 04:59 AM