1

This question is an exact duplicate of:

I need to transform this table

enter image description here into this one, with de Services columns as rows:

enter image description here

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

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

0
=ARRAYFORMULA({SPLIT(TRANSPOSE(A2&"|"&B2&"|"&TRANSPOSE($C$1:$E$1)&"|"&C2:E2),"|");
               SPLIT(TRANSPOSE(A3&"|"&B3&"|"&TRANSPOSE($C$1:$E$1)&"|"&C3:E3),"|");
               SPLIT(TRANSPOSE(A4&"|"&B4&"|"&TRANSPOSE($C$1:$E$1)&"|"&C4:E4),"|");
               SPLIT(TRANSPOSE(A5&"|"&B5&"|"&TRANSPOSE($C$1:$E$1)&"|"&C5:E5),"|")})

here is the spreadsheet: https://docs.google.com/spreadsheets/d/

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