Hi, I'm having a little difficulty with the data below: datalines; 01OCT2017 XX-1 XX  0 01JAN2018 XX-1 XX  7320 01APR2018 XX-1 XX 30240 01JUL2018 XX-1 XX  40600 01OCT2018 XX-1 XX  45360 01JAN2019 XX-1 XX  29302 01APR2019 XX-1 XX  0 01OCT2017 XX-2 XX  0 01JAN2018 XX-2 XX  7320 01APR2018 XX-2 XX  30240   In the above data each individual, signified with the -(number) is part of the overall group XX. Each individual was given a certain amount of money, denoted by the final column; however, the numbers shown are incorrect, as they signify the total for the group, not the individual (as in, for period 1 Jan 2018, 7320 was issued for XX in total, not just XX-1).   I want to find a way to report out the money given out per time period for XX without the duplicating of values in the money column. Ideally it should look something like this:   Time Period   Group   Money Issued 01OCT2017   XX        0 01JAN2018    XX        7320 01APR2018   XX        30240 01JUL2018    XX        40600   and so on.   Could someone help with thinking this through? ... View more