Macro to copy data saved in one column to multiple columns

[G_Andersen]

Hello!, first of all, thanks for your attention.

I am really new to VBA and I'm self-learning, so I am really sorry if this is a easy task and I am doing it completely wrong, I promise to keep learning.

After performing a cyclic experiment, the experimental results I get from the software are saved in .csv files, using column A for "X" values and B for "Y" values. The data for each cycle is separated with 5 rows. The "X" values for each cycle remain constant, this is, the values always repeat. I have attached one as example.

I would like to have a macro that can transform those two basic columns in a table with a column for "X" values, and as many "Y" columns as cycles I performed in the experiment. So I was thinking of using a while loop, that stops when the are no more values to copy.

As a draft I tried to write this code, but I get several errors:

Please Login or Register  to view this content.

Also, how could I use this macro in several different files? Is there any way to execute it without copying and pasting the code in each one?

Thanks a lot, any help is welcomed