I have following table:
ID Event Event2 Event3
102 181 182 184
103 5 7 8
I want to convert in into:
ID Event
102 181
102 182
102 184
103 5
103 7
103 8
I tried with pivot table but no success. How to do this?