CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaarray-formulasgoogle-sheets-query
Laila Van Ments
Laila Van Ments

Reputation: 147

Query and transpose a long row of data Google Sheets

I have rows of data with a lot of columns, example:

Date=Team2:Date Date Exercise 1 Reps Weight Team Exercise 2 Reps Weight

9/18/2019        9/18/2019   chinup       10        2       2    situp         10     3

I want to pull the data in another sheet as follows:

Date=Team2:Date    Exercises    Reps    Weight   Team
   9/18/2019       chinup       10      2        2

   9/18/2019       situp        10      3        2

I tried a combination of query and transpose but am not getting the result I want. Is this possible at all?

Upvotes: 2

Views: 2449

Answers (1)

player0
player0

Reputation: 1

if AddTraining sheet is like:

0

then you can use:

=ARRAYFORMULA(QUERY({
 AddTraining!A2:A, AddTraining!C2:E; 
 AddTraining!A2:A, AddTraining!G2:I; 
 AddTraining!A2:A, AddTraining!J2:L; 
 AddTraining!A2:A, AddTraining!N2:P; 
 AddTraining!A2:A, AddTraining!R2:T; 
 AddTraining!A2:A, AddTraining!U2:W; 
 AddTraining!A2:A, AddTraining!X2:Z; 
 AddTraining!A2:A, AddTraining!AA2:AC}, 
 "where Col2 is not null
  order by Col1", 0))

0

spreadsheet demo

Upvotes: 2

Related Questions