Forum Discussion
How to merge multiple rows into single cell using Power Query
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 😊