Hello Excel Gurus-

I need some assistance converting some cells in a spreadsheet in OFFICE 2003-

It would be best if I can email a sample, so let me know if that is OK--

but, here goes-

we have a spreadsheet with the following details

column A has in
A1- PRODUCT PART NUMBER A
A2- PROUCT DESCRIPTION A
A3- SPACE
A4- PRODUCT PART NUMBER B
A5- PRODUCT PART DESCRIPTION B
and so on...

We need to create a new column to the left of the existant column A,
then, need to take the data in the OLD CELL A1 (now B1 once we add a new column to the left of this current data) and then have the data in what is now B1 (old A1) to show up next to (in to the new COLUMN A) the data in B2 (which was A2)-- essentially we need everything to show up in one row , side by side from two rows on top of each other---there again is a space (blank row) in between each set of PART NUMBER and associated PRODUCT DESCRIPTION- so, that needs to be accounted for too-
We have 1000's of part numbers to apply this to- so, any help you can give to solve this problem would be invaluable to us!