Excel将单元格移动到单独的列

I have been given a spreadsheet that has a single column with odd numbered rows containing a value and even numbered rows containing an associated date. I would like to convert this into a format where the odd row values have their assocated date in the same row but a separate column, e.g.I have been given a spreadsheet that has a sing