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)
Ned Krastev
Instructor
Posted on:
20 Mar 2023
0
Hi Dijana,
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.