Resolved: Using Text to Columns
Is it easier and safer, since we know as you said, that period has digits in all cses to use Text to Columns option with fixed weidth? We would end up in rows as well, split for Month and Year.
1 answers ( 1 marked as helpful)
Any approach that would split the data correctly is more than welcome! Feel free to try and experiment with different approaches. If you're able to split the data properly, then that's perfect.