Combining information VB script

Hi All,

I am looking for a VB script which will help me combine information which I currently do manually.

I have attached the current spreadsheet in which i use.

I am looking for the following:


Sheet 2 Col A should show all the types of fruit from Sheet 1 Col A without the duplicates e.g. only 1 instance of 'Apple'
Sheet 2 Col B should have the sum of all the same types of fruit from Sheet 1 Col E E.g. Apple would have 5 (1+4)
Sheet 2 Col C should have the sum of all the same types of fruit from Sheet 1 Col F E.g. Apple would have 2 (1+1)
Sheet 2 Col E should have the sum of all the same types of fruit from Sheet 1 Col H E.g. Apple would have 3 (0+3)
Sheet 2 Col G should have the average of all the same types of fruit from Sheet 1 Col J E.g. Apple would have 3 ((4+2)/2)


Any help would be massively appreciated and save a lot of time!

with a pivot table, see the attached file.

Hi!

Thank you for this! Is there a way of filtering on the pivot table to only show priority 1's?

yes that is possible, see the attached file.