I have a table which contains Item and its Sales.
I need Sum of all items & the column may have delimiter with “,”.
How Can I do it in either Power Pivot or Power Query.
Table1
** Expected Output**
Cl_1 Cl_2
Rose 4
Pink,Yellow,Red 17
Louts 3
Green,white 5
Result
Thanking you.
New contributor
User1_1 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.