Hi there, was just wondering how I would able to combine 2 lists together so columns in list one are combined with columns in list 2. In the example below both list have ClientID and FiscalYear.
- Lists 1:
- ClientID | FiscalYear | TotalCars
- 1 19-20 100
- 1 20-21 230
- 2 19-20 50
-
- List 2:
- Client ID | FiscalYear | NumOfShops
- 1 19-20 5
- 1 20-21 6
- 2 19-20 4
-
- Is there a way to combine both of those list into 1 so that the data is like:
-
- ClientID | FiscalYear | TotalCars | NumOfShops
- 1 19-20 100 5
- 1 20-21 230 6
- 2 19-20 50 4
Thanks!