I have my data like this:

10-Oct 11-Oct 10-Oct 11-Oct 10-Oct 11-Oct

and

005S0F1 009F00OL 017S0D1

I am trying to create this:

005S0F1 005S0F1 009F00OL 009F00OL 017S0D1 017S0D1
10-Oct 11-Oct 10-Oct 11-Oct 10-Oct 11-Oct

Thank you in advance.

In A1: =INDEX($A$12:$C$12,ROUNDUP(COLUMN()/2,0))
copy across to F1
In A2: type date 1
In B2: type date 2
Select A2:B2 copy then select C2:F2 and Paste

"carl" wrote:

I have my data like this:

10-Oct 11-Oct 10-Oct 11-Oct 10-Oct 11-Oct

and

005S0F1 009F00OL 017S0D1

I am trying to create this:

005S0F1 005S0F1 009F00OL 009F00OL 017S0D1 017S0D1
10-Oct 11-Oct 10-Oct 11-Oct 10-Oct 11-Oct

Thank you in advance.