Split Dataset into a variable amount of slices, transponse them and merge them again

Question

Hello together,

it's my first post. Thus, "Hello" to everyone.

I need help with following problem:

I have a dataset of following struchture.

xyr_1##r_2##r_3##s_1##s_2##s_3##...  z_1##z_2##z_3##

What I want to do, is, split the dataset into slices (varies between 1 to z).

x_ry_rr_1  r_2  r_3

x_sy_ss_1  s_2  s_3

x_zy_zz_1  z_2  z_3

After that i want to transponse these slices

r_1r_2r_3x   y

and put them back together

r_1r_2r_3x_r   y_r   x_s   y_s   ...   x_z   y_z

I really appreciate any help :)

See you

Thomas

Hakimipous · Accepted Answer

Hey @Piedy !

Welcome to our great community :D

I tackled this using a batch Macro, here is attached my solution.

Please let me knows if that helps x)