Split worksheet columns into more columns (same worksheet) based on numer of rows

Hello everyone,

I have the following question:

I have an Excel file with 1 sheet consisting of 8 columns and a number of rows. The number of columns could change, attached is just an example file.

I would like to take a predefined number of rows and columns, say 8 columns (in this case) and 2000 rows (not in this case, from the DataSource.jpg file, and place it in the empty columns starting after the last column of data, do that twice so the result looks like DataSplit.jpg.

I need a macro or VBA for this since the real source-files are 6000+ rows and maybe more or less than 8 columns.

I hope i have explained the situation well.

Any help greatly appreciated!

Beste regards,

Ribka

DataSource.jpgDataSplit.jpg

Hi Alan,

Thanks for reply. I will look into it.

Also attached file which was used for screenshots in first post.

Best regards,

Ribka