Split and rearrange one row into 3 rows (22000 rows to appr.66000)

Hello everyone!
Rob here

I am a total newbie to excel, no experience in programming generally unfortunately. I searched online for my answers and so far havent figured out how to to what I need.

So I have a dataset that consists of roughly 22000 rows as shown below (A - AI). There are 35 columns, two of which are only as optical "seperators", column L and column X, however those
columns could be deleted as they are not needed after the process, so all in all I have effectively 33 columns that I want to be devided to 3x11 columns.

I attached a sample file, the first line shows what I have, couple lines below the format I want.
To give an idea, I want to go from this format:

PHP Code: 

A B C D E G H I J K L M N O P Q R S T U V X Y Z AA AB AC AD AE AF AG AH AI 


to:

PHP Code: 

A  B   C  D  E  F  G  H  I  J  K

M  N   O  P  Q  R  S  T  U  V  W

Y  Z  AA AB AC AD AE AF AG AH AI 


Note, the column (that is, variable names) of A to K repeat from M to W and again from Y to to AI which is why I want to rearrange each row into 3 rows. For example A, M and Y would all have the name "#" and B,N,Z all have the name "type" and so on. I would want to keep the names of the columns.
The first row of the file is all variable names, so the data starts in row 2.

So, I want row 1 to be split and become row 1, 2 and 3. For the former row 2, I want it to be split to row 4, 5 and 6. And so on. Each row would have 11 columns.

An example how each row looks (A-K, M-W and Y to AI)

PHP Code: 

2 XYZ 14.01.21 A1234567 123-456-789-a Test_01_AA_001 samplematerial 1,000 36567 5436356 0 


Note, I left out columns "L" and "X" because they are empty and are optical "seperators" when all items are arranged in one row. I think it would make sense to not copy them when splitting since they are no longer needed. I could just delete them.

In columns "W", "K" and "AI" value is "0" in all rows.


Any help would be appreciated, as mentioned, I am totally new to excel and wasnt able to adapt other similar formulars.
Also as a side note, I have a work laptop so I'm not the admin and some functions like VBA or macros probably are limited.

Cheers
Rob

Should works:

Please Login or Register  to view this content.