Copy, Paste, repeat data until no more data

[aznprod517]

Hello,

I'm trying to have my program loop so that it copies the row below "OWA" in column B, and pastes it after the last cell in row 1, and then copy 2 lines below "OWA" and then paste it after the last cell in row, after it has done the first loop. I would then delete row 2 and 3, and then repeat until this is done. Is there a way to loop it?

Thank you,

Please Login or Register  to view this content.

[Mallycat]

So your data is wrapped over 3 lines, and you want it all in 1 line, right?

[Mallycat]

how about this.

Please Login or Register  to view this content.

Not it assumes there are always 3 lines of data to be consolidated into 1

[Mallycat]

By the way, your data looks faulty. If it is systemic, this alternative will fix it for you.

Please Login or Register  to view this content.

[aznprod517]

Thank you.

I recognized the 1A being offset as well later in the night, so I was able to delineate it a bit better so all the #A would be in the same column so I modified the code to incorporate that, but when I tried to use your consolidate code, it just didn't copy it over. Did I mess something up?

[Mallycat]

The file format in this book testing.xlsm is different to the sample you posted previously. That is why it is not working. I am happy to take another look at this, but I want to be sure about the file format first.

1. This new file has 3 rows of data at the top that are different to those in the rest of the file - why is that?
2. Columns G and I have no data in the rows that have data in Column A. Why is that?

The only way to do this is to get a file format that is locked down, then you can automate the process. But if you make changes like happened before, all the work is wasted.

[aznprod517]

Sorry about the confusion.

1. The first 2 rows was just what I was hoping it would end up looking like. I reuploaded the file on what it looks like when I delinieate it.
2. Columns G and I don't have data because there is a double space function when I transpose the data.

[Mallycat]

try this

Please Login or Register  to view this content.

[aznprod517]

Thanks! This is totally what I'm looking for.