How to auto merge same value cells. (H\V) [Closed]

Report
Posts
1
Registration date
Monday April 21, 2014
Status
Member
Last seen
April 21, 2014
-
Hello,

I want to merge same value cells in both rows and columns.

for example i'll be having:

| 2 2 2 2 2 3 3 3 3 3
| 2 2 2 2 2 3 3 3 3 3
| 2 2 2 2 2 4 4 4 4 4
| 2 2 2 2 2 4 4 4 4 4

I want them to be

|..................|
|..................|.....3
|.......2.........|
|..................|.....4


I use Lingo (optimization application), and the data will be writing in lots of numbers, and i want to merge all same value numbers (if they are adjacent).

I only found programs will work by rows, i couldn't find something will do both rows and columns together.



Thanks you!