Convert multiple rows to one single column

Hello Expert,

I have a huge excel sheet in the format below

Service Group | Service1 | Service 2 |Service3 | Service4|------Service8

Sg1 S1 S2 S3 S4---------S8
Sg2 S1 S2 S3 S4---------S8
Sg3 S1 S2 S3 S4---------S8

and I want my excel to be in the below shown pattern.
Service Group | Service
Sg1 S1
S2
S3
Sg2 S1
S2
S3
Sg3 S1
S2
S3

I know that I can do it by copying and transposing data. But I have huge list. If I do copy/paste It will take me ages.
So, is there any way that I can automate the process by any vba or any function. I would appriciate if you can pass me any suggestions.

Thanks
Rashme

Hello Rechard,

Thank you very much for your solution, I am exactly loking for what you have shown in the attached file.
But I am new to excel so, can you please tell me how to split the pivot table values into columns.

Thanks
Rashme