Reversing a Comma Separated String

[AbhishekMehta]

 Hi Everyone, 

Hope you are doing great. 

I'm actually stuck on one step where I need to reverse a comma separated string. 

My String looks like this: this, on, help, need, I 

I want the value this way: I, need, help, on, this

Note: The no of comma separated values in each row is different. 

I would really appreciate if someone can help me out with this. 

Thanks 

[DavidP]

Hi @AbhishekMehta 

Something like this?

[AbhishekMehta]

Thank you, appreciate your help. 

However this would consolidate data from all rows into just one cell. The data set that I have has thousands of rows:

Input Data

Row No	Data Values
1	Feature,Control
2	this,on,help,Need
3	serious,so,Why
4	Roger,is,Name,My,Hello

Expected Output:

Row No	Data Values
1	Control,Feature
2	Need,help,on,this
3	Why,so,serious
4	Hello,My,Name,is,Roger

Please let me know your thoughts on this. 

Thanks

[DavidP · Accepted solution]

Hi @AbhishekMehta 

In that case I'll use a tile tool and grouping option in the Summarize tool, like this:

[AbhishekMehta · Accepted solution]

This is Perfect, Thank you so much 🙂