Moving data from one cell to another in new column

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!

I suggest that you attach a small workbook here, illustrating how your data are laid out, and how you would like them laid out.

Here ya go--
first is sample
second is for how I would like it to look--
Please kindly keep in mind that I am not Excel savy whatsoever-- so, baby food-style would be appreciated

Chris

Is there not some forumula that can be applied to the current "before" spreadsheet to convert it in to the "finished" product?
we have 1000's of part numbers to apply this to-not sure what you mean by
copy and paste values- please again I am completely Excel inexperienced...

Try these formulae, copied down:

In B1 =OFFSET($A$1,(ROW()-1)*3,0,1,1)

In C1 =OFFSET($A$1,3*ROW()-2,0,1,1)

I have attached my results--- what do you think I am doing wrong?
I am just following your instructions below--
does it work for you?