Move Blocks Of Data In Columns To Rows

Dear all

Moving Data And Deleting Blank Rows

I am a complete newbie to excel VBA and require assistance.

I have data in the following format in an excel sheet in 4 column but I wish to separate it (i.e. move data along onto the first row in other columns) and delete blank rows.

But I want to move the data along on the correct line (as mentioned) and delete remaining rows.

I have about 67,000 of rows in each column.
I would like to move the data to a new sheet. I included a sample file.

If anyone coud help me out it would be greatly appreciated.

Originally Posted by phillim

Dear all

Moving Data And Deleting Blank Rows

I am a complete newbie to excel VBA and require assistance.

I have data in the following format in an excel sheet in 4 column but I wish to separate it (i.e. move data along onto the first row in other columns) and delete blank rows.

But I want to move the data along on the correct line (as mentioned) and delete remaining rows.

I have about 67,000 of rows in each column.
I would like to move the data to a new sheet. I included a sample file.

If anyone coud help me out it would be greatly appreciated.

Hi

The following VBA procedures should do it. Please note the assumption that the top of the original data, in the example you attached cell A4 should be given the name "Top". The macro uses this as an anchor.

The way it's written, all your data is first sorted chronologically, and the new layout therefore has the data cascading left to right downwards. If you need to keep the original row order, then this will need modifying. i.e. the original order of the data would need to be noted in a separate column, and used in the new sheet as one of the last lines of code.

I've not cleaned up the original sheet which contains a new column showing a 'proper' Excel date number and a lookup table.

Regards

Please Login or Register  to view this content.