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

Question

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 DescriptionVehicle YearFuel TypeConsumptionCostDate1Toyota2021Diesel248.002024/01/131Toyota2021Diesel7625.332024/01/281Toyota2021Diesel3411.332024/01/292Jaguar2023Gasoline258.332024/01/122Jaguar2023Gasoline134.332024/01/142Jaguar2023Gasoline6923.002024/01/263Mercedes2022Diesel7224.002024/01/113Mercedes2022Diesel4715.672024/01/133Mercedes2022Diesel186.002024/01/30

cingham · Accepted Answer

Thanks @binuacsfor 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 Answer

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