Intracolumn data

I have 3 columns as below. I need to find a way to create a new table which tells me the difference between the first value according to date and last value, for each unit. I am not to familiar yet w...