I have a set of data where commas act as the delimiters and periods act as range/wildcard. As an example I need to transform something like this:
column 1 column 2 column 3
500 1000, 1002.1004, 1032 3
Into this:
column 1 column 2 column 3
500 1000 3
500 1002 3
500 1003 3
500 1004 3
500 1032 3
What is the most effective way to do this for a large data set? I feel it should be pretty straightforward but was hoping to get some help.
Solved! Go to Solution.