Combine two sheets in Google sheets
Clash Royale CLAN TAG #URR8PPP Combine two sheets in Google sheets I'm trying to combine two sheets in a Google Sheet. The first sheet contains a simple list of names similar to this: +--------+ | Name | +--------+ | Bob | | Vivian | | Fred | +--------+ The second sheet contains a list of tasks similar to this: +------------+---------+ | Task | Task ID | +------------+---------+ | Do Dishes | 1 | | Vacuum | 2 | | Do laundry | 3 | +------------+---------+ I want to combine these so that I get a sheet with those tasks for each name in separate rows: +--------+------------+---------+ | Name | Task | Task ID | +--------+------------+---------+ | Bob | Do Dishes | 1 | | Bob | Vacuum | 2 | | Bob | Do laundry | 3 | | Vivian | Do Dishes | 1 | | Vivian | Vacuum | 2 | | Vivian | Do laundry | 3 | | Fred | Do Dishes | 1 | | Fred | Vacuum | 2 | | Fred ...