I've seen many questions on merging, but nothing that I can manipulate (in my entry-level abilities) to answer this particular question and would be forever be grateful for your expertise and help!!!
I am looking to merge different groups of cells with the same values for particular ranges.
Below is an example of inputs and the desired outcome. I have the file formatted so that the "0"s and "no"s don't show, however the actual descriptions (substituted with like 50% off) are quite long and cannot be viewed in a single cell, hence the need for merge cells to better display information. There are also multiple stores with new stores being added weekly, thus I would like to avoid merging cells manually.
Input
Month January February March April May Store 1 Campaign Period no yes yes yes no Campaign Details 0 50% off 50% off 50% off 0 Store 2 Campaign Period no no no yes yes Campaign Details 0 0 0 spring fling spring fling
Desired Output
Month January February March April May Store 1 Campaign Period no yes yes yes no Campaign Details 0 50% off 0 Store 2 Campaign Period no no no yes yes Campaign Details 0 0 0 spring fling
Aucun commentaire:
Enregistrer un commentaire