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:
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.)
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!
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](/board/proxy.php?image=http%3A%2F%2Fup.ijihad.com%2Fimages%2F2014%2F05%2F11%2FScreen_Shot_2014-05-11_at_4.png&hash=2c1ea7995cde0aebbe06a2b365a6c674)
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](/board/proxy.php?image=http%3A%2F%2Fup.ijihad.com%2Fimages%2F2014%2F05%2F11%2FScreen_Shot_2014-05-11_at_46FDQO.png&hash=82445238d2816acce8f357e727949c4e)
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!