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