VBA Insert multiply rows and Transpose from Row to Column

[TCookie]

Hi,

Could you please help me on the below.
I need transform the top table to the bottom table using Loop.

Name Age English Maths Science
Adam 24 1 2 3
John 32 4 5 6
Lisa 12 9 8 7



Name Age Subject Score
Adam 24 English 1
Adam 24 Maths 2
Adam 24 Science 3
John 32 English 4
John 32 Maths 5
John 32 Science 6
Lisa 12 English 9
Lisa 12 Maths 8
Lisa 12 Science 7


Any feedback is much appreciated.

Thanks.

[karedog]

Hi,

Please Login or Register  to view this content.

Regards

[TCookie]

Bingo!! That's exactly what I needed. Thank you very much for your help.

[karedog]

You are welcome, glad I can help.


Regards

[TCookie]

Above is a small example of the big table I have.
I was hoping to be able to alter from your answer above and to use it on over 200 Contracts (Cntractx) and 800 people (Rows) But I can't.
Could you please help?

Name City County Detail ID Cntract1 Cntract2 Cntract3 ..........................
A Pboro Cambs SDec14 NGE £100 £200 £300 ...............................
B Lei Leis SDec14 KDJ £743 £378 £783 ...............................
C Bham Midlands UMay15 JEK £222 £2,780 £89 ................................
D Glgow Scotland UMay15 DJE £398 £989 £898 ................................
.
.
.
.

Thanks.

[karedog]

Could you upload a copy of your workbook ?
I only need first 5 rows of the data.

[TCookie]

Please find file attached.
Many thanks.

[karedog]

Here we go :

Please Login or Register  to view this content.

Regards

[TCookie]

Perfect!! Thank you so much.

[fshbet]

Hi TCookie,

Please find the attachment. I have resolved it.

Copy of Book1.xlsm

[karedog]

You are welcome, glad I can help.


Regards