Forum Discussion
How to merge multiple rows into single cell using Power Query
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
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
5 Replies
freginierSolution Sage
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....
- freginier
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
