Convert Single Row To Multiple Rows

Macro to sort column data.

I have a spreadsheet in the following format (just a flavour of the format)

SD 1
SD2
SD3
1a
1b
1c
2a

[Code]...

Each row refers to a survey response, the first ten columns being standard demographics.

Following this each group of 5 columns for the next 100 columns represents a single response. What I want to do is convert each single row to multiple rows with the same first 10 columns and each single response on its own row like so:

SD1
SD2
SD3
a
b
c
a

[Code]...

I found an excellent similar example on this board here Convert a single row to multiple rows with the same A column value However I would like my macro to convert to rows even if the cells are blank So each existing row will generate 10 individual reponse rows regardless of data found).

I am interested to know how this would work and how i could modify the variables to acommodate 15 standard demographic fields and 20 columns per individual responses.