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 |
Solved! Go to Solution.
@OvieAhweTR
Something like this?
@Emil_Kos
Oh, Maybe I should not have used the filter.
@OvieAhweTR
With or without filter
Thanks for for the speedy response @Emil_Kos - works fine!