dimanche 28 mai 2017

Merge columns where cells have same values, excluding "0"s

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