Hi,

You should really put your data into a normalised 2D table such that it can easily be analysed/summarised either with a pivot table or functions. So change your layout to columns for

Date
Name
Sales Amount
Profit Amount

Then you'll be able to use a Pivot Table.