Google Sheets transposing multiple column data into row

1
votes

https://i.stack.imgur.com/fWOec.png

I need to transpose the left table data into the right table data in Google Sheets. I don't know which formula to use

1
google-sheetstransposearray-formulasgoogle-sheets-formulagoogle-sheets-query
Have you already tried =TRANSPOSE(A1:N5) ? - mukund
It doesn't work, thanks - Tes
Do you want to know how to obtain result dataset or you just want to know the function in spreadsheet that does the transpose? If it is about the function then above formula should work, given that you've changed spreadsheet settings for iterative calculation to "ON" . - mukund

1 Answers

0
votes

use:

={"ID", "Task", "Weekday"; 
 ARRAYFORMULA(TRIM(SPLIT(TRANSPOSE(SPLIT(QUERY(IF(LEN(A3:A), 
 "♦"&B3:B&"♥"&A3:A&"♥"&A1&"♦"&D3:D&"♥"&C3:C&"♥"&C1&
 "♦"&F3:F&"♥"&E3:E&"♥"&E1&"♦"&H3:H&"♥"&G3:G&"♥"&G1&
 "♦"&J3:J&"♥"&I3:I&"♥"&I1&"♦"&L3:L&"♥"&K3:K&"♥"&K1&
 "♦"&N3:N&"♥"&M3:M&"♥"&M1, ), , 999^99), "♦")), "♥")))}

0