Grouping by Column Contains?

amitchandak great this looks like it works correctly. Where I am confused is how would I add additional levels to this though? 

I can't have the non-designated values reflect as "Type", they will need to follow a logic  where if the new value is not Long then it becomes a different variable


For Example:


Calc = var _1 = COUNTX(FILTER(Sheet1,[Transaction #] =EARLIER([Transaction #]) && CONTAINSSTRING([Type],"Baseball")),[Transaction #])
Return if(ISBLANK(_1),[Type],"Baseball")

Would I be able to have it designate those as Baseball and if the new Calc is not Baseball and  [Type] contains Long then Cacl = Long?