Nilhan Perera

  Hey Guys,  Recently I came across a requirement that needed a table with an unpivoted structure to be transformed in such away that it is grouped by a single column and the second column holds comma separated values of the corresponding column instead of it being split into rows (Example below). Original Table   Resultant Table I tried different approaches that included pivoting the table, replacing values with the required name, merging the columns, and replacing "0". It worked! But as all things are, its just not that simple. The requirement also required that additional batches could also be added to an existing fruit later. That meant it had to be dynamic. The search continued. I stumbled upon a similar requirement on the Power BI forum that suggested using the Table.Group along with Table.Combine functions using M Query. I incorporated it to the solution, and it worked like magic.  I followed the steps below on Power Query Editor, Group table by Fruit ->