N
nikkynock
hi - i work with a lot of sales unit data, and need to total weekly sales
data of duplicates under one row name. For example, i would like to turn the
raw data from this:
A B C E F
product wk1 wk2 wk3 wk4
product a 2 3 4 5
product b 6 7 8 9
product a 10 11 1 13
..........into the following (with originals deleted)
A B C E F
product b 6 7 8 9
product a 12 14 5 18
would really appreciate your help
thanks
data of duplicates under one row name. For example, i would like to turn the
raw data from this:
A B C E F
product wk1 wk2 wk3 wk4
product a 2 3 4 5
product b 6 7 8 9
product a 10 11 1 13
..........into the following (with originals deleted)
A B C E F
product b 6 7 8 9
product a 12 14 5 18
would really appreciate your help
thanks