Macro to combine cells in a row to 1 cell while skipping blank cells

Hello,

I need to combined all non blank cells in a given row into 1 cell. But within each row i have 5 phases that the values fall into, which is denoted by the 1st charter 1, 2, 3, 4, or 5. for example, in a given row i have 1-a, 1-c, 2-d, and 1-f and these values occurs in non consecutive columns starting from G to ALR. I need a macro that sorts these values in one of the 5 phases. So in another sheet the macro would combined [1-a 1-c 1-f] in Phase 1 and [2-d] in phase 2. and if there are other phases it would put them in the appropriate cell.

Please help! Thanks. See attached workbook.

Hi,

Something like this...?

Please Login or Register  to view this content.

Note that you will need to change the value of endRow for your actual data set

you hit the bull's eye on this one. its perfect. thank you very much.

No problems.

Please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved)