Compressing columns

[ExcelJWS]

Hi guys,

I have a problem that I'm not sure how to deal with. My data looks like that in the left table (see Attached), And I want to compress the columns by removing blank spaces (see Attached), hopefully I would end up with just one final column, but i need to be able to make sure that if there is 2 or more data on the same row, that they don't overwrite each other.


Thanks Guys

[TMS]

Post a sample workbook. The forum removes excess spaces so your example doesn't work well in explaining your requirement.

[ptmuldoon]

I did a quick try,

This shift the data over once, but not quite right.

I think you need to evaluate each row first to find the last used cell to move to. Or maybe there's a better way? Or maybe loop the For Each for the number of columns you have so it runs multiple times.

Please Login or Register  to view this content.

[AB33]

The attached code works on the attached sample.

[ExcelJWS]

Im looking at your code, trying to understand ti so I can adapt it to my workbook.

what does "&" do?

[AB33]

It is short name for a long

k& means k as long