Forum Discussion
Split Columns
I have a column of merged data which stores a type and a number and sometimes several types and numbers. I would like to br able to report on the different types and their values but I can't figu...
BhaveshPatel shows a good solution. One thing to consider is to be careful when the number of items to split may increase (I couldn't quite tell from the screen shots if Bhavesh's solution handles this)
see this article for what I'm referring to
https://www.linkedin.com/pulse/take-care-when-splitting-cells-wyn-hopkins
This is your sample column, "Type C: 8; Type F: 2;Type B: 4;Type L: 4;"
Split first by the delimiter ';' and then split the resulting colums by delimiter ':'. Shouldn't cause a probem ideally