Extracting multiple entries in a cell into their component pie
When you define ArrayB, include as many columns as the biggest entry.
You will get lots of zeros in the output column.
To get rid of them and justify up, select the output and
Edit Go To Special Formulas Numbers
Delete Shift cells up
This assumes your data is text, as it is now.
If it is not, I got a fix for that too.
|