Power Query Question

%3CLINGO-SUB%20id%3D%22lingo-sub-2938568%22%20slang%3D%22en-US%22%3EPower%20Query%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938568%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20per%20the%20attached%20file%2C%20is%20it%20possible%20to%20get%20the%20output%20which%20is%20on%20the%20right%20side%20of%20the%20sheet.%20Left%20side%20one%20is%20the%20actual%20raw%20data.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2938568%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938669%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1145786%22%20target%3D%22_blank%22%3E%40ParasUdani%3C%2FA%3E%26nbsp%3BPerhaps%20by%20splitting%20up%20the%20query%20in%20three%20separate%20parts.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2938690%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2938690%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20if%20the%20category%20column%20is%20dynamic%20and%20it%20may%20have%2015-20%20categories.%20So%20this%20would%20become%20very%20much%20manual%20right%20%3F%20(Currently%20for%20demo%20purpose%20-%20I%20just%20kept%203%20categories).%20So%20is%20there%20a%20way%20in%20power%20query%20that%20it%20would%20identify%20unique%20Category%20and%20post%20which%20gives%20desired%20output.%20(horizontally%20left%20to%20right%20)%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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. 

4 Replies

@ParasUdani Perhaps by splitting up the query in three separate parts. See attached.

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 )??

@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.

You're right

Just that we need to work on some tracker and going it horizontally will give us more visibility in regards to multiple categories.