I still don't understand some of the requirements.

StoreId, Open Date, Closed Date , ReOpen Date, Closed Date 2, ReOpenDate 2 .......

There can be no Reopen & Re-Close for a store or the store could have been closed twice and reopened twice etc.

you said There can be no Reopen. Why is it that there is a ReOpen Date field in your report?