Sort List (A1, A2, A3,...,B1, B2, B3, ...) > (A1, B1, A2, B2, A3, B3, ...)

[HebHeb]

Hello,

 

how can I sort my List that is ordered like this:
A1, A2, A3,...,B1, B2, B3, ...
to:

A1, B1, A2, B2, A3, B3, ...

 

I guess this is a easy thing to accomplish? But I lack the basic skills ;D

Thank you!

Edited January 23 by Heblon

[PatW]

Here is a solution that works with a list that has na even amount of members. For uneven lists you could addd another placeholder value and remove it from the final list again.

 

 

zipList_v2020.vwx

Edited January 23 by PatW

[HebHeb]

Thank you!
This is working great.