Reverse Text to Columns

Question

Hi,

I have the table like below:

12AFree Kane|Kate|Jessica||||BFreeman|Kiliman|Warn Kale|Low Jis||

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

12.12.22.32.42.52.6AFree KaneKateJessica   BFreemanKilimanWarn KaleLow Jis

But my expected output is this one:

12.12.22.32.42.52.6AJessicaKateFree Kane   BLow JisWarn KaleKilimanFreeman

I would need the output rows reversed.

Many thanks for the help.

Qiu · Answer

@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.

Jeff_Neklason · Answer

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 · Answer

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

Reverse Text to Columns-r1.yxmd