I'm importing a rather akward .xlsx file. The table structure looks
Company Project Invoice Number Amount
Company x
project b
###### $#####
###### $#####
Company y
project c
###### $#####
It carries on like this for a quite some time.
These are weekly reports (from outside vendor) modifing them directly is not really an option. The bosses don't care about real time either they prefer "Snap Shot" data analysis.