CODEWITHSUNDEEP
google-sheetstransposearray-formulasgoogle-sheets-formulagoogle-sheets-query
Tes
Tes

Reputation: 65

Google Sheets transposing multiple column data into row

https://i.sstatic.net/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

Upvotes: 2

Views: 2298

Answers (1)

player0
player0

Reputation: 1

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

Upvotes: 1

Related Questions