I am reading in a table that shows the First Date of a Motel Stay and how many consecutive nights they stayed. I want to create a record for each niht d stayed.
Please refer to attached.
Book3.pdf (15.0 KB)
How could i do this with Excel PQ?