Excel 2007 : Distinguish between Text and Numbers then Move

[dennymigl]

Help !!

I recently scanned and converted a pdf file into an Excel 2007 file.
A portion of that file is attached.

Column A shows a list of property names (text format) on one row with its respective value (number format) shown in the row immediately below it. There are 3 blank rows immediately following the value (number format) that separate each property/value combination (see attachment).

I would like to move the value (number format) for each property name (text format) from the cell immediately below the property name to the cell immediately to the right of the property name. I still need to maintain the 4 row separation between property names.

There are two worksheets in the attachment:
Existing Format
Desired Format

I can cut and paste for a few properties, but not when there are several thousand.
There's got to be a better way!

Help !!

Thanks !!