I have two columns in Google Sheets, and I would like the product of a cross-join:
Student ------- Jake John Sally Grace Days ----- 1/1/15 1/2/15 1/3/15 1/4/15
For example, if these were tables in SQL, and I did a cross-join, I would get
Days Students ------ -------- 1/1/15 Jake 1/1/15 John 1/1/15 Sally 1/1/15 Grace 1/2/15 Jake 1/2/15 John 1/2/15 Sally 1/2/15 Grace 1/3/15 Jake 1/3/15 John 1/3/15 Sally 1/3/15 Grace ...
Is there a simple way to do this in Google Sheets? I need to use Google Sheets to track students switching between classrooms (In week 1 Jake is in classroom A, but in week 2 Jake is in Classroom B). The only way I can figure to do this is to expand a list of students per day as above. However I'm definitely open to other suggestions.