Group data into months using start date and end date without removing other columns

[cingham]

Hi There

I have a configured script where the output data contains all the data I need but I need it to sum all the consumption and cost by month returning the start date of the 1st of the month (01/01/2024) and the end date of the last date of that month (31/01/2024). E.g. Lump each Vehicle's consumption and cost together for the month of Jan and include the Vehicle Year and Fuel Type.

I've tried using the summarize function but it stripped out the Vehicle Year and Fuel Type. Would appreciate someone explaining to me what I'm doing wrong. 

Basic version of the original data below: 

Vehicle	Description	Vehicle Year	Fuel Type	Consumption	Cost	Date
1	Toyota	2021	Diesel	24	8.00	2024/01/13
1	Toyota	2021	Diesel	76	25.33	2024/01/28
1	Toyota	2021	Diesel	34	11.33	2024/01/29
2	Jaguar	2023	Gasoline	25	8.33	2024/01/12
2	Jaguar	2023	Gasoline	13	4.33	2024/01/14
2	Jaguar	2023	Gasoline	69	23.00	2024/01/26
3	Mercedes	2022	Diesel	72	24.00	2024/01/11
3	Mercedes	2022	Diesel	47	15.67	2024/01/13
3	Mercedes	2022	Diesel	18	6.00	2024/01/30

[binuacs]

@cingham one way of doing this by calculating the first of the month and last of the month then you can use the summarise tool

[cingham · Accepted solution]

Thanks @binuacs for your response. It worked with the text but when I replace it with the excel file the output was blank. I'd also like it to remove the original date column too - any hints please? 

[cingham · Accepted solution]

Thanks @binuacs - I managed to work it out using your previous response - thanks for your help here - it's much apprecaited.