Copy nth Row Cell to Column

I want to copy the dates shown in the merged cells from Sheet1 to a single column in Sheet2, but unsuccessful. Does the merged cell make a difference?

Cheers.

You can use this formula in cell B2 of Sheet2:

=INDEX(Sheet1!$2:$2,(ROWS($1:1)-1)*4+2)

Copy it down as required.

Hope this helps.

Pete

Worksheet or Tab name : sheet2
Cell B2 formula , drag down

Formula:

Please Login or Register  to view this content.

Thks, both formulas do the job.

@Ian McPherson You're Welcome. Glad to help . Thank You for the feedback and rep.