I created a pivot table but the end result has many empty blanks and
unecessary totals, please does anyone know how I can sort and or filter the
columns without messing up my data. I need just clean rows and of data
without the spaces and the total. I have 20 columns and thousands of rows

All help will be greatly appreciated. Thanks