Hi
i have a sheet that contains 4 columns ,like this:
store# cabinet # device # INFO

15 3 4 xyz
15 3 5 y1
15 4 2 yy
15 5 0 cc
15 4 1 ff
14 4 rr
......


etc


knowing that the third column should contain numbers from 0 to 25 for each unique column1,column2 values .

that is :
there should be finally for the column1 column2 values 15 3 (column3 from 0-25)
15 3 0
15 3 1
15 3 2
..until.....
15 3 25

and the same for each other values of column1 column2
and this should be sorted according to column3 from 0-25.
note: if column3 value is not available (from 0-25) we should add a row including column1 column2 and the missing number from column3 and in the fourth column we add the word "nothing"

.

example input file:
=====================
29 4 14 device-1
29 4 13 device-1
29 5 10 device2-222
29 5 5 device2-222
29 5 22 device2-222
29 5 21 device2-222
29 5 19 device2-222
29 5 18 device2-222
29 5 16 device2-222
29 5 8 device2-222
29 5 3 device2-222
29 5 2 device2-222
31 1 18 AAA
31 1 12 AAA
31 1 8 Ccc
29 5 13 ccccc
29 5 17 ccccc
29 5 7 device2-TRH
29 5 12 CEEE
31 0 25 SSSSd
29 76 0 FFFF
29 82 0 FFFF
29 88 0 FFFF
31 32 0 FFFF
31 40 0 FFFF



Thanks