Reverse Text to Columns

[MahmudSaniat]

Hi,

I have the table like below:

1	2
A	Free Kane|Kate|Jessica||||
B	Freeman|Kiliman|Warn Kale|Low Jis||

I have tried Text to column and could reach up to this:

1	2.1	2.2	2.3	2.4	2.5	2.6
A	Free Kane	Kate	Jessica
B	Freeman	Kiliman	Warn Kale	Low Jis

But my expected output is this one:

1	2.1	2.2	2.3	2.4	2.5	2.6
A	Jessica	Kate	Free Kane
B	Low Jis	Warn Kale	Kiliman	Freeman

I would need the output rows reversed.

Many thanks for the help.

[Luke_C]

Hi @MahmudSaniat 

Can you clarify what you mean by 'reverse the output'? The text to columns tool should achieve what you're looking for. How have you configured it?

[MahmudSaniat]

Sorry, perhaps the description was not clear enough. I have updated it. Many thanks.

[Jeff_Neklason]

Not elegant and could probably be done in less tools, but, this could get you there consistently.

[Qiu]

@MahmudSaniat 
Almost same approach with @Jeff_Neklason , but use a Tile tool instead.

[Jeff_Neklason]

Good morning @Qiu,

I thought you would like to know that I have now spent the last 15 min watching @mceleavey try to solve this one. I am cheering him on, but it is not looking good.  Also, I like the Tile approach! good work.

Jeff

[Qiu]

@Jeff_Neklason 
OMG, Its you my friend. I did not realize that is you.

Since you mentioned @mceleavey, I thought who is this Jeff😁

Really nice to "See" you again.