Help please- Grad.Project - Merge ALL cells with same value in a sheet? [rows AND columns]

Hello there,

We are doing a graduation project on an international airport, consist of scheduling flights on check-in counters automatically.

long story short, we ended up with an excel sheet like this:
Screen_Shot_2014-05-11_at_4.png


Were y-axis are the check-in counters and x-axis is the timeline horizon (cell per 5-minutes)

I will do a VLOOKUP, to change each flight number to it's ID from an other sheet.

But the problem is that i want to AUTO-MERGE all cells with same value, because they represent one flight! and if i shortened the column width i can't see anything.

I want it to be like this: (i've done this manually, and it's VERY time consuming with errors because we have to do it for all days.)


Screen_Shot_2014-05-11_at_46FDQO.png


I googled for days, i only found Visual basic commands i guess? that only merge same rows. and they were poorly made. beside that it didn't work properly.

Could anyone please help me with a method to do it automatically?


EXCEL 2013


Thanks a lot!


NOTE: i only posted the question in mrexcel forums here, i wouldn't do it normally, but we are late for deadline. sorry.

Originally Posted by GC Excel

Hi,
Try this code :

Please Login or Register  to view this content.

Thanks A LOT! this is amazing, it worked like a charm. Much thanks you helped me big time!