Excel or OpenOffice Table Summary: how to reconstruct a table from another, with "missing" values
- by Gilberto
I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g.,
MONTH | CODE | VALUE
1 | aaa | 111
1 | bbb | 222
1 | ccc | 333
2 | aaa | 1111
2 | ccc | 2222
The codes are clients and the values are sales volumes. Each row represents the sales for one month for one client. So I have three…