Track length of visit on pivot table
Hi all! I'm looking for help to create an ETL from which I can create a pivot table to track when people are in town through our organization to have a guest census by month. I've attached test data. The values in the test data are personID, ActualArrivalDate, DepartDate, and Housing. I'd like the result to look like this,…