change table structure

[1tmoomt1]

Hi Guys,
this is my first thread and I hope I dont come across to stupid..
Its a bit tricky to explain. But I think from the pictures below, you can figure out what I am trying to do...

Is there any formula or VBA I can use?

I need to change the structure of a table and tried for hours how to do it, but didn't manage.

before (this is how it is)
1.png

after (this is how it should be)
2.png

Thanks, tmo

[Roel Jongman]

a simple index formula can do that for you.

for the name column to be.. use

Please Login or Register  to view this content.

for each next column only the (red) 1 in the formula needs to be changed to 2,3 and 4
*4 makes the row number to find jump by 4 to the next record.
the ROW()-2 makes sure that for the first record it is 0*4 so 1+0 = use row 1 of the tablerange B2:B21 or cell B2

see also the attachment.

[1tmoomt1]

Dear Roel,
this is amazing and so fast...Thanks a lot!