Converting one row of data into specific columns by category

[simsa4]

Hi, I am uploading a template of what I am hoping to achieve on Alteryx. I currently have all my data in one row after using the sum tool. There are multiple "teams" such as "Reds" "Sox" & "Pirates" with different sub categories "hot dogs" "ice cream" "baseballs" etc. of data that needs to be put into their respective column under the assigned team. I am also hoping to create a gross total row at the bottom to summarize how many units each of the teams have sold. Thank you in advance for all your help!

[cjaneczko]

Try This. If your Team Names have more than one word, you are going to have to alter the RegEx to accommodate.