Automating data consolidation

[pelachrum]

Hello,
How do I automate the following repetitive procedure? This would be done on a group of cells manually selected among other content.
The data is organized in rows of 2 (ie. as multiple two-line entries) but it needs to be consolidated into 1 row using this method here:

xcel.jpg
...this is the visual

1. Second line of each entry, column B: value needs to move to first line, column C
2. Columns D and E will have their values staggered; sometimes D will have value in first line and E in second (case 1), other times D will have its value in line two and E in line one (case 2). In case 1: first line, column A should receive value "X", in case 2: first line, column A should receive value "Y". Values in columns D and E do not need to be modified themselves.
3. Second line of each entry, column F: value needs to move to first line, column F
4. Second line of each entry needs to be deleted altogether

Any help is appreciated. Thanks!

[arlu1201]

Why upload a jpg when an excel file will be better?

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.

[kvsrinivasamurthy]

Try this macro

Please Login or Register  to view this content.