transpose block of two-two column in row

[arun198322654]

i have 20 dates in one column. mention below :
1 07.02.2013
2 31.05.2015
3 14.02.2013
4 14.02.2016
5 11.02.2013
6 11.02.2016
7 02.03.2013
8 02.03.2016
9 26.02.2013
10 24.02.2016
11 04.03.2013
12 30.06.2015
13 09.03.2013
14 09.03.2016
15 21.03.2013
16 21.03.2016
17 19.03.2013
Now i want to transpose it into row in below mention format
7-Feb-13 31-May-15
4-Mar-13 30-Jun-15
19-Apr-13 30-Jun-15
14-Oct-13 31-Jul-15
30-Jun-14 30-Jul-15
30-Sep-07 1-Jun-15
14-Feb-13 14-Feb-16
11-Feb-13 11-Feb-16
2-Mar-13 2-Mar-16
26-Feb-13 24-Feb-16
9-Mar-13 9-Mar-16
21-Mar-13 21-Mar-16
19-Mar-13 19-Mar-16
5-Jun-15 30-Jan-16


Request to help. thanks in advance

 

[NARAYANK991]

Hi ,

See this file.

I have defined a named range called ListOfDates ; you will need to create this in your file if you wish to use the formulae.

Narayan

 

[Vishal Srivastava]

i have 20 dates in one column. mention below :
1 07.02.2013
2 31.05.2015
3 14.02.2013
4 14.02.2016
5 11.02.2013
6 11.02.2016
7 02.03.2013
8 02.03.2016
9 26.02.2013
10 24.02.2016
11 04.03.2013
12 30.06.2015
13 09.03.2013
14 09.03.2016
15 21.03.2013
16 21.03.2016
17 19.03.2013
Now i want to transpose it into row in below mention format
7-Feb-13 31-May-15
4-Mar-13 30-Jun-15
19-Apr-13 30-Jun-15
14-Oct-13 31-Jul-15
30-Jun-14 30-Jul-15
30-Sep-07 1-Jun-15
14-Feb-13 14-Feb-16
11-Feb-13 11-Feb-16
2-Mar-13 2-Mar-16
26-Feb-13 24-Feb-16
9-Mar-13 9-Mar-16
21-Mar-13 21-Mar-16
19-Mar-13 19-Mar-16
5-Jun-15 30-Jan-16


Request to help. thanks in advance

Try this and drag it down:
=IFERROR(INDEX($A$2:$A$18,2*(ROWS($1:1)-1)+COLUMNS($A:A)),"")