Exchange adjacent seats.

[amitsingh88]

Hi,

I have input data like this-

+---------+---------+
|    id   | student |
+---------+---------+
|    1    | Abbot   |
|    2    | Doris   |
|    3    | Emerson |
|    4    | Green   |
|    5    | Jeames  |
+---------+---------+

And I want output like this 

+---------+---------+
|    id   | student |
+---------+---------+
|    1    | Doris   |
|    2    | Abbot   |
|    3    | Green   |
|    4    | Emerson |
|    5    | Jeames  |
+---------+---------+

 if number of rows are odd, we can skip last row exchanging seats.

I tried to do using Multi Row with no success.

Please look into it.

Thanks,

Amit Kumar

[atcodedog05 · Accepted solution]

Hi @amitsingh88 

Here is how you can do it. Grouping 2 rows and switching order.

Workflow:

Hope this helps : )

[messi007 · Accepted solution]

@amitsingh88,

Another way to do it 🙂

Attached the workflow,

Regards,

[amitsingh88]

Thanks a lot!!

[atcodedog05]

Happy to help : ) @amitsingh88 

Cheers and have a nice day!