Exchange adjacent seats.

Question

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 Answer

Hi @amitsingh88

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

Workflow:

Hope this helps : )

messi007 · Accepted Answer

@amitsingh88,

Another way to do it 🙂

Attached the workflow,

Regards,