Trick 011 Merge multiple rows into one cell with power query
On Sale
$999.99
Sometimes, you need to combine multiple rows into one cell. To do this in excel we can use the CONCATENATE function. With simple data we can do it easily.
But when we have big data or when we need more data than the original, using the CONCATENATE function is no longer effective.
So is there a way to make this work? Using VBA???
