Databases
StackOverflow2013
Postsdbo
PODynamically fusion rows cells with same values in Excel
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODynamically fusion rows cells with same values in Excel
    text
    copied!<p>In a datasheet with automatic filters, I have this (values and columns names are for example) :</p> <pre><code>Continent Country City Street ---------------------------------------------------------- Asia Vietnam Hanoi egdsqgdfgdsfg Asia Vietnam Hanoi fhfdghdfdh Asia Vietnam Hanoi dfhdfhfdhfdhfdhfdh Asia Vietnam Saigon ggdsfgfdsdgsdfgdf Asia Vietnam Hue qsdfqsfqsdf Asia China Beijing qegfqsddfgdf Asia China Canton sdgsdfgsdgsdg Asia China Canton tjgjfgj Asia China Canton tzeryrty Asia Japan Tokyo ertsegsgsdfdg Asia Japan Kyoto qegdgdfgdfgdf Asia Japan Sapporo gsdgfdgsgsdfgf Europa France Paris qfqsdfdsqfgsdfgsg Europa France Toulon qgrhrgqzfqzetzeqrr Europa France Lyon pàjhçuhàçuh Europa Italy Rome qrgfqegfgdfg Europa Italy Rome qergqegsdfgsdfgdsg </code></pre> <p>I would like this to be displayed like this, with rows fusionned dynamically if filters changes</p> <pre><code>Continent Country City Street ---------------------------------------------------------- egdsqgdfgdsfg Hanoi fhfdghdfdh Vietnam dfhdfhfdhfdhfdhfdh Saigon ggdsfgfdsdgsdfgdf Hue qsdfqsfqsdf --- Asia Beijing qegfqsddfgdf China sdgsdfgsdgsdg Canton tjgjfgj tzeryrty --- Tokyo ertsegsgsdfdg Japan Kyoto qegdgdfgdfgdf Sapporo gsdgfdgsgsdfgf --- Paris qfqsdfdsqfgsdfgsg France Toulon qgrhrgqzfqzetzeqrr Europa Lyon pàjhçuhàçuh Italy Rome qrgfqegfgdfg qergqegsdfgsdfgdsg </code></pre> <p>Is macro mandatory for this ?</p> <p>I don't want to merge values in Street column. I want to keep all lines. I just want to work on the first column display to avoid having long series of same values.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload