How to merge multiple rows into single cell using Power Query

[HappyHappyCoder]

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

[freginier]

Does the number of lines change ?

______________________________________________________

If you found this post helpful, please give Kudos C

[HappyHappyCoder]

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 · Accepted 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

[HappyHappyCoder]

It worked! Thank you so much 
Best regards,

[freginier]

Your welcome so you can accept as solution 😊