Forum Discussion
stephr
6 years agoRegular Visitor
Sum of one specific value with multiple values in a cell
Hi, I have a table looking like this : content pageviews M01 12 M02,M03 8 M01, M02, M03 4 M03 2 I would like to create a table with the sum of each "M", the result w...
- 6 years ago
stephr
In Power Query, go to your table. right-click on the content column and choose, split column by delimiter, and choose By Row under advanced, Then, Right-click on the content column and select Group By________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
6 years agostephr
In Power Query, go to your table. right-click on the content column and choose, split column by delimiter, and choose By Row under advanced, Then, Right-click on the content column and select Group By
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂