I would like to test the following flow in excel, but I’m not seeing how to do it:
- Open a csv file
- save it as an xlsx file
- change the headers of the columns to new names (half of all the columns)
- hide certain columns
- Delete the 3 bottom rows that contain values
- Sort on more than 1 field
I’m having some issues for starting with point 3 and 4 and 5. Does anyone has some tips or maybe a file where you are performing a similar exercise?
Thanks in advance!
Have a nice day.