Curious if there's anything I can do with data currently in a Field that looks like this:
AAA; BBB; CCCC; EEE-EE; FFF; GGG and GGGGG;
Basically, this was repeating data that was concatenated into one field and delimited by ";"
I have a table that I'm passing back into PowerPivot that I can use to "clean" the field; however, I'm not entirely sure how I would clean it. All I'm trying to accomplish is a visual representation of how prevalent "AAA" is when compared to "BBB" across all of the records.