CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulagoogle-sheets-querygs-vlookup
MB32
MB32

Reputation: 33

Is there a way to link data by names in Google Sheets?

I am using Google Forms and Sheets to create a way of tracking services including time for some of our students. I have the forms linked to a Sheet and am able to pull the "Clock In" data and "Clock Out" data into a single sheet. My issue is: when I go to analyze using pivot tables it pulls the data from the cell of the next row (students do not necessarily clock in/out in the order they arrive). Is there a way I can link the data by name and then order by time?

Any help would be greatly appreciated!

Quick View of Issue

Example Sheet

Upvotes: 2

Views: 130

Answers (1)

player0
player0

Reputation: 1

you can but not in one go because pivot tables are not so advanced. create a new sheet and paste this in A1 cell and then crate your pivot table from this sheet:

={QUERY({Combination!A1:E}, "where Col1 is not null order by Col3, toDate(Col1) , toDate(Col2)", 1),
  QUERY({Combination!F1:I}, "where Col1 is not null order by Col3, toDate(Col1) desc, toDate(Col2) desc", 1)}

0

Upvotes: 1

Related Questions