I have some columns in my Excel data which have multiple values separated by commas. I want to be able to find % of total for each item but since some rows have multiple values I can't get the correct percentage.
I tried splitting each value into it's own column but there are too many values. Is there a dynamic solution where I can get 5 of total for each value?
If the number of value in one cell is small enough (Let's say 5 ), you can use this appraoch
(Union , split and merge)
Please refer my post in the link.
Duplicate data up to the number of value in one cell.