Excel VBA Report

I would like to take an exported CSV file and manipulate the data into a custom daily report. It will require filtering and removing unwanted columns and doing some calculations with the data and transposing some columns into rows based on a specific variable.