Trick 011 Merge multiple rows into one cell with power query

 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???

  In this article, I introduce to you another way that is to use Power Query.

  With Power query, we only need to do it once. When updating data, the power query automatically updates the results. Using power query also does not burden the spreadsheet and power query is also available in excel without having to install an additional app