Moving Rows and Columns with a Macro

[mtcnd2002]

I have a massive data file with thousands of lines of data. Each line is a pair, for example

Please Login or Register  to view this content.

I want to take the Description that is located on two lines within the same row and change it so the new columns would be:

Please Login or Register  to view this content.

It is possible to create a macro that would do this for every pair?

[Leith Ross]

Hello mtcnd2002,

Welcome to the Forum!

Would it be Okay to transfer the information over to a new sheet? This would be faster and not disturb the original data.

[mtcnd2002]

Hello,

Moving the information to a new sheet would not be a problem.

[Leith Ross]

Hello mtcnd2002,

This macro will restructure the original data on another worksheet. In this case the worksheets are "Sheet1" (Source) and "Sheet2" (Destination). Both sheets' data start at cell "A2"

Please Login or Register  to view this content.

[mtcnd2002]

Hello mtcnd2002,

This macro will restructure the original data on another worksheet. In this case the worksheets are "Sheet1" (Source) and "Sheet2" (Destination). Both sheets' data start at cell "A2"

Please Login or Register  to view this content.

This macro worked well for me but I am having trouble adjusting it for some new data problems. The data is in four rows and one column. The data is listed like this:

A
B
C
D
E
F
G
H

Etc.

I want to convert so it is listed like this:
A B C D
E F G H

Is there a way to adjust this macro to do that?

[Leith Ross]

Hello mtcnd2002,

Here is another macro to convert your data. This takes the data in a single column divides into groups of 4 rows and copies these rows to another sheet.

Please Login or Register  to view this content.

[mtcnd2002]

Thank you this worked well to fix the problem.

I can't seem to mark this as solved... it doesn't give me an edit button on the first post.