I have few records stored as '07, '03, '05, '06 in the excel. I want that each record of '07,'03 , '05, '06 should start from next column and in the same row.

For Example:
Currently situation is as follows:
Column 1 Column 2
'07 INDIA
'07 Delhi
'07 123
'03 AAA
'05 XXXQQ

I want them to be like:
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6
'07 INDIA '03 AAA '05 XXXQQ
'07 Delhi
'07 123

Please let me know the solution.