Split columns in to rows in google spread sheets [duplicate]

Question

This question is an exact duplicate of:

• Transpose Ranges repeated by row 1 answer

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?

Answer 1

try this:

=ARRAYFORMULA({SPLIT(TRANSPOSE(A2&"|"&"|"&$B$2:$D$2);"|");
               SPLIT(TRANSPOSE(A3&"|"&"|"&$B$3:$D$3);"|")})

---

custom formula builder: https://docs.google.com/spreadsheets/d/