I have a column of data which has to be split into columns, I did try a RegEx but couldn't get the right expression. What is the best approach to solve this ?
10-31-2015@11213@100@1.36 |
101@12545@09-23-2015@25.8965 |
18.1436@12-04-2016@85485@102 |
103@67218@9.34@11-05-2014 |
12.2365486@05-27-2019@104@84651 |
This is the result I want to achieve.
A | B | C | D |
100 | 11213 | 1.36 | 10-31-2015 |
101 | 12545 | 6.58 | 09-23-2015 |
102 | 85485 | 4.23 | 12-04-2016 |
103 | 67218 | 9.34 | 11-05-2014 |
104 | 84651 | 12.23655 | 05-27-2019 |
Solved! Go to Solution.
@atcodedog05 Brilliant as always. Thank you . This is an amazing solve.
Happy to help : ) @Mario36
Cheers and have a nice day!