Combining multiple columns into one column without any blanks

[Tuanfeng]

Hi there,

I have an excel file with data ranging from column B to column BJ, with a lot of blank cells. Now I want to combine all the data into column A with a structure of one item per row, without any blank cells. Could you please help me achieve that? I've attached the sample sheet for your convenience. Thanks in advance.

[Kaper]

Try simple macro:

Please Login or Register  to view this content.

[Tuanfeng]

Awesome!!! That's exactly what I was looking for. Thanks a lot!