Moving Excel Data with a Macro

[RoseMClark]

I have a spreadsheet with columns A-T, but column A has data in A2, A3, then A4-T4, the next row is blank then the structure is repeated. I need to move the data in A2 and A3 to be in the same row as the complete line.... here is a sample

00-01-2654 [EA]
DIAPHRAM PUMP, P1/PPPPP/TNU/TF/KTV

0000102840 19-Apr-11 AMERIS 580.00 680.00 0.00 1 680.00 100.00 14.71

00-0240 [EA]
HEATER 50W 240V

0000081404 22-Mar-05 REPIND 20.00 38.00 0.00 1 38.00 18.00 47.37

00-057B424 [EA]
NOZZLE, TAPER, .020

0000089950 20-Sep-07 HARPAC 12.97 17.00 0.00 3 51.00 12.09 23.71
0000089982 20-Sep-07 HARPAC 12.97 17.00 0.00 3- 51.00- 12.09- 23.71
0000089983 20-Sep-07 HARPAC 12.97 17.00 0.00 3 51.00 12.09 23.71
0000090721 10-Dec-07 AGEIN2 14.25 18.50 0.00 2 37.00 8.50 22.97
0000090747 10-Dec-07 AGEIN2 14.25 18.50 0.00 2- 37.00- 8.50- 22.97
0000090748 10-Dec-07 AGEIN2 14.25 18.50 0.00 2 37.00 8.50 22.97

[arlu1201]

It will be good if you attach a sample file instead of showing the data here.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.