To move Data rows to columns against one cell so can write separate SQL insert statments

[hadster016]

I have scoured the web to move data from a row
ie

name no1 no2 no3 no4 ...no8
. . . . .
. . . . .
. . . . .
to
name no1
name no2
name no3

So then you can write SQL inserts against each line and insert into a database.

On this forum I have seen to go from columns to rows but not the other way round!

I learnt some VBA from excel pratique site and wrote the vba script to do it. Never done VBA before this but hit the fustration of developing which is why I dont like coding.
Had to use 4 counters and solve some sequence math. As you have to count in 8s for the columns.

If anyone has a better easier to do this then please advise.Samplenamesnumbersrowsforexcelforum.xlsx

Have attached a sample spreadsheet, obviously I have modified the numbers and names to protect privacy.