Text to column and re-align or move text entries accordingly

[OvieAhweTR]

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

[Emil_Kos · Accepted solution]

Hi,

I have prepared a workflow for you.

And the output:

Please let me know if this work for you.

[Qiu]

@OvieAhweTR 
Something like this?

[Qiu]

@Emil_Kos 
Oh, Maybe I should not have used the filter.

[Qiu]

@OvieAhweTR 
With or without filter

[Emil_Kos]

Hi @Qiu,

Probably not 🙂

[OvieAhweTR]

Thanks for for the speedy response @Emil_Kos  - works fine!