Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
How can I merge multiple rows into a single cell? I need to use this in a CSV file and each cell holds alot of attribute info about the item, so I need to be able to condense tables into singular cells.
This is the starting data:
I'm exhausted... I can't cant farther than just comining "Column1" and "Column2" but I'm unable to find a way to do this with rows... Does anyone know of the correct function?
Thank you so much for your time in advance,
Best regards
Solved! Go to Solution.
The only way is to transpose your query > merge columns > transpose your query
but if number of row change it will be difficult because power query need column name to merge...
______________________________________________________
If you found this post helpful, please give Kudos C
Does the number of lines change ?
______________________________________________________
If you found this post helpful, please give Kudos C
Yes the number of lines might change. So I would have to be able to do something like "Select whole Column1" and transcribe whole column into single cell....
The only way is to transpose your query > merge columns > transpose your query
but if number of row change it will be difficult because power query need column name to merge...
______________________________________________________
If you found this post helpful, please give Kudos C
It worked! Thank you so much
Best regards,
Your welcome so you can accept as solution 😊