Forum Discussion
HappyHappyCoder
3 years agoRegular Visitor
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 in...
- 3 years ago
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
HappyHappyCoder
3 years agoRegular Visitor
It worked! Thank you so much
Best regards,
freginier
3 years agoSolution Sage
Your welcome so you can accept as solution 😊