Shifting rows of data so that they all line up in the same column

[Ricker090]

I have a report that spits out data and the data is all over the place. I'm trying to write a macro that shifts the data so that it all lines up in the same columns.

I've already written a macro, but it has proven to be slow and inefficient over a large amount of data. Any help is appreciated. Please see the attached workbook for an example.


Shift Rows Example.xlsm

[Paul]

Hi Ricker, perhaps this will suffice? It deletes all blank cells in the range B1:Z? (where ? is determined as the last used row in column A). It then inserts a column before B1 creating the column-gap you want.

Please Login or Register  to view this content.

[Ricker090]

Yep that helps tons. Thanks!