1

This question is an exact duplicate of:

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?

marked as duplicate by Rubén, serenesat, jonsca Aug 19 '18 at 22:08

This question was marked as an exact duplicate of an existing question.

1

try this:

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

enter image description here


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

enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.