Hello everyone,

This is my first post so hopefully it is to standard. Anyways, to the point...

I have a Excel sheet that contains a calendar I made (using a Query from Access) that contains the fields Year, Quarter, Month, Week, Date, LC where LC = Location.

Because the data I am working with has 2 locations I need to make a copy of each date.

Example of what I have:

Year Quarter Month Week Date LC
2014 Q4 November Week 48 11/23/2014 ORD
2014 Q4 November Week 48 11/24/2014 ORD
2014 Q4 November Week 48 11/25/2014 ORD

Example of what I am looking for:

Year Quarter Month Week Date LC
2014 Q4 November Week 48 11/23/2014 ORD
2014 Q4 November Week 48 11/23/2014 FMT
2014 Q4 November Week 48 11/24/2014 ORD
2014 Q4 November Week 48 11/24/2014 FMT
2014 Q4 November Week 48 11/25/2014 ORD
2014 Q4 November Week 48 11/25/2014 FMT

I hope that makes sense and thank you in advance to everyone who helps!

- Eric B.