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
Solved! Go to 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)
Thank you very much :) It helped a lot