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

[Piedy]

Hello together,

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

I need help with following problem:

I have a dataset of following struchture.

	x	y
r_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_r	y_r
r_1
r_2
r_3

	x_s	y_s
s_1
s_2
s_3

	x_z	y_z
z_1
z_2
z_3

After that i want to transponse these slices

	r_1	r_2	r_3
x
y

and put them back together

	r_1	r_2	r_3
x_r
y_r
x_s
y_s
...
x_z
y_z

I really appreciate any help :)

See you

Thomas

[Hakimipous · Accepted solution]

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)

[Piedy]

Thank you very much :) It helped a lot