Can anyone Help me Group this Data by total looking at following categories.
I have multiple, multiple tons of sample data in Sheet 1 Cell A and B.

Sheet 1
Cell A Cell B(Category)
hunt_un1 Farm
Ninja_y8k Movie
broomWju Restaurant
myGyro Restaurant

Sheet 2
Cell A Cell B Cell C
Cell D Cell E
Row 1 ID hunt_un1 Ninja_y8k broomWju myGyro
Row 5 Plate $20 $100 $77
$50
Row 6 Bowl $0 $33 $41
$39
Row 7 Spoon $9 $56 $40
$74

I want to get the following e.g For Plate, look at Row 5 in Sheet 2 and give
me amount with the category. Because plate has $20 under hunt_un1, then its
category is Farm with $20. Same for other IDs
ID Category Amount
Plate Farm $20
Plate Movie 100
Plate Restaurant $127 (this adds $77+$50)
Bowl Farm $0
Bowl Movie $33
Bowl restaurant $80 ($39+41)
and so on€¦..
Please Help me out. My categories are in multiples and I have to lookup row
1 per their category before grouping them in Total. All help totally
appreciated.
Thanks