How to write multiple range excel in multiple columns in outputdata table

Hello Everyone !
I want to copy N ranges from a column and paste it near the column. For example if the column A has 20 rows, I want to split the column in ranges of 5 rows , so I will have 5 ranges that I want to copy right after the source column B ,C and in excel. Thanks!

1 Like

could you explain your problem by picture as once ?


here I have output from 6 sheet but I want to put the shets in multiple column. for example if I have 6 shets copied in data table I want make to see 1 2 3 4 5 6 not

Is somebody can help me with this step ? please ?