Hi
Can someone please provide some advice on how to achieve a task?
Problem: I've managed to split the entries in a column into three columns with the 'text to column' tool as you can see. However, the text entries are not consistent - you can see 'Users' is present in TXT_1, TXT_2 and TXT_3.
Ideally, I'd want to create 3 new columns (USERS, CREDITS and UNITS) to hold their corresponding entries just as I have it in the example.
| Text to column | New columns | |
| TXT_1 | TXT_2 | TXT_3 | USERS | CREDITS | UNITS | |
| Credits=38800 | Units=1 | Users=6000 | Users=6000 | Credits=38800 | Units=1 | |
| Credits=2000 | Users=356 | Units=1 | Users=356 | Credits=2000 | Units=1 | |
| Credits=1000 | Units=1 | | | | | |
| Credits=140 | Units=1 | | | | | |
| Credits=200 | Users=50 | | | | | |
| Credits=407 | Users=44 | | | | | |
| Units=1 | Users=14000 | | | | | |
| Units=8 | Users=150 | | | | | |
| Credits=330 | Units=1 | | | | | |
| Credits=115 | Users=25 | | | | | |
