Help Merging Data into a sorted worksheet
Total Sales By Customer By Month 2013 vs. 2014
CUSID CUS Name Oct-13 Nov-13 Dec-13 2013 Total Oct-14 Nov-14 Dec-14 2014 Total
236 VRTE Co 14,215.39 9,986.12 24,201.51 23,250.17 14,273.29 37,523.46
689 SWR LLC 97,216.85 102,346.98 199,563.83 65,302.67 201,203.22 266,505.89
782 OLLY Inc 108,779.99 93,882.14 223,765.34 74,298.97 163,555.98 237,854.95
220,212.23 206,215.24 426,427.47 632,642.71 1,059,070.18 1,691,712.89
236 1,791.17
689 142,111.93
782 267,458.11
986 112,436.87
236 48,000.03
689 202,107.54
782 110,412.82
986 103,556.30
After sorting by Column A (CUSID) I get the following:
CUSID CUS Name Oct-13 Nov-13 Dec-13 2013 Total Oct-14 Nov-14 Dec-14 2014 Total
236 VRTE Co 14,215.39 9,986.12 24,201.51 23,250.17 14,273.29 37,523.46
236 1,791.17
236 48,000.03
689 SWR LLC 97,216.85 102,346.98 199,563.83 65,302.67 201,203.22 266,505.89
689 142,111.93
689 202,107.54
782 OLLY Inc 108,779.99 93,882.14 - 74,298.97 163,555.98 237,854.95
782 267,458.11
782 110,412.82
986 112,436.87
986 103,556.30
1582 156,877.92
When what I really need is the following:
CUSID CUS Name Oct-13 Nov-13 Dec-13 2013 Total Oct-14 Nov-14 Dec-14 2014 Total
236 VRTE Co 14,215.39 9,986.12 1,791.17 24,201.51 23,250.17 14,273.29 48,000.03 37,523.46
689 SWR LLC 97,216.85 102,346.98 142,111.93 199,563.83 65,302.67 201,203.22 202,107.54 266,505.89
782 OLLY Inc 108,779.99 93,882.14 267,458.11 - 74,298.97 163,555.98 110,412.82 237,854.95
986 112,436.87 103,556.30
1582 156,877.92
Please help me solve this - the real worksheet has more than 36 columns.
- SHerebia's blog
- Login or register to post comments
- 2192 reads
add an example workbook
add an example workbook