Adding a blank row after Totals

Question

Hi everyone, I have data like so and I've got a running total for each manufacturer what I need to do is put in a single blank line after the last line for each manufacturer so the data can feed easily into an excel macro:

Input:

Vehicle ModelVehicle Registration NumberManufacturerKilometers DrivenFuel TypeTransmissionEngine CCHorsepowerSeatsCar PriceRunTot_Car PriceVolvo V40 D35YJ3E1EBXJVolvo33000DieselAutomatic1984150511212.4125115.75Volvo XC60 D55YJSA1E22FVolvo106976DieselAutomatic2400215511310.7336426.48Volvo XC60 D5 Inscription5YJSA1E2XJVolvo86925DieselAutomatic240021555982.942409.38Volvo S80 2006-2013 D5JHMZC5F11LVolvo92098DieselAutomatic240021557688.3650097.74Volvo XC60 D5KM8KMDAF2PVolvo173000DieselAutomatic240021557243.0757340.81Force One LX 4x41G1RA6S55HForce41000DieselManual2200139.01711339.9511339.95Force One LX ABS 7 Seating5YJXCBE47LForce41000DieselManual2149139.0778455.6619795.61Force One LX 4x4JTMFB3FV3MForce50000DieselManual2200139.0179567.2929362.9Honda Amaze VX i-DTEC1C4JJXN6XPHonda15388DieselManual149898.6513899.9413899.94Honda Amaze S i-Dtech1C4JJXR69MHonda89429DieselManual149898.6512391.0426290.98Honda City 1.5 V MT1C4RJXR6XRHonda94832PetrolManual1497118511596.3137887.29Honda City V MT Exclusive1C4RJYC69PHonda56000PetrolManual1497116.3511254.0749141.36Honda City ZX VTEC1C4RJYD69NHonda95000PetrolManual1497100512124.0961265.45Honda City 1.5 EXI1FADP3R43DHonda125943PetrolManual149310057982.1769247.62Honda City 1.5 S AT1FMCU0LZ4NHonda73095PetrolAutomatic149711856756.9276004.54Honda City V MT Exclusive1FTBW1XK3NHonda53442PetrolManual1497116.3513245.6689250.2Honda Brio V MT1FTVW1EV6PHonda59000PetrolManual119886.8514644103894.2

Output:

Vehicle ModelVehicle Registration NumberManufacturerKilometers DrivenFuel TypeTransmissionEngine CCHorsepowerSeatsCar PriceRunTot_Car PriceVolvo V40 D35YJ3E1EBXJVolvo33000DieselAutomatic1984150511212.4125115.75Volvo XC60 D55YJSA1E22FVolvo106976DieselAutomatic2400215511310.7336426.48Volvo XC60 D5 Inscription5YJSA1E2XJVolvo86925DieselAutomatic240021555982.942409.38Volvo S80 2006-2013 D5JHMZC5F11LVolvo92098DieselAutomatic240021557688.3650097.74Volvo XC60 D5KM8KMDAF2PVolvo173000DieselAutomatic240021557243.0757340.81           Force One LX 4x41G1RA6S55HForce41000DieselManual2200139.01711339.9511339.95Force One LX ABS 7 Seating5YJXCBE47LForce41000DieselManual2149139.0778455.6619795.61Force One LX 4x4JTMFB3FV3MForce50000DieselManual2200139.0179567.2929362.9           Honda Amaze VX i-DTEC1C4JJXN6XPHonda15388DieselManual149898.6513899.9413899.94Honda Amaze S i-Dtech1C4JJXR69MHonda89429DieselManual149898.6512391.0426290.98Honda City 1.5 V MT1C4RJXR6XRHonda94832PetrolManual1497118511596.3137887.29Honda City V MT Exclusive1C4RJYC69PHonda56000PetrolManual1497116.3511254.0749141.36Honda City ZX VTEC1C4RJYD69NHonda95000PetrolManual1497100512124.0961265.45Honda City 1.5 EXI1FADP3R43DHonda125943PetrolManual149310057982.1769247.62Honda City 1.5 S AT1FMCU0LZ4NHonda73095PetrolAutomatic149711856756.9276004.54Honda City V MT Exclusive1FTBW1XK3NHonda53442PetrolManual1497116.3513245.6689250.2Honda Brio V MT1FTVW1EV6PHonda59000PetrolManual119886.8514644103894.2

binu_acs · Answer

@Deano478 Another option with batch macro

Insert_Blank_05032024.yxzp

danilang · Answer

Hi @Deano478

You can do this by adding a RecordID that you convert to double.  Grab the last record from the original set grouping by manufacturer and add 0.5 to the Record ID.  Select only the RecordID to blank out the other fields and union this to your original data.  Sort by Record ID which is then removed

Dan

BlankRow.yxmd

jdminton · Answer

You could do this, but if you want Volvo first, you might need to set a sort order. This does it alphabetically.

Add blank row.yxmd