Hi,

My data is from a grocery store in the UK and consists of 3 columns. The first represents a unique ID for each trade, the second the number of items in each trade, and the third at what time the trade was completed:
id number_of_goods time
1 2 12oct2017 12:23:33
1 1 12oct2017 12:23:33
1 3 12oct2017 12:23:33
2 1 26jan2018 09:31:45
2 2 26jan2018 09:31:45
2 5 26jan2018 09:31:45
3 6
03feb2018 17:53:02
My wish is to get each ID on a separate line, so that each ID comes with the numbers of items summed up and with the corresponding date and time:
id number_of_goods time
1 6 12oct2017 12:23:33
2 8 26jan2018 09:31:45
3 6 03feb2018 17:53:02
I hope some of you have the opportunity the help me.