Hello, trying to figure out how to use formulas in Excel to process the following data (top rows in table) and get to the desired result (lower rows in table). Any help is much appreciated. Thank you.

Data to be filtered and combined        FruitApplesBananasBananasBananasBananasPears Pears BananasApplesApplesSale?SaleSaleRegularRegularSaleRegularRegularSaleSaleRegularNumber?100100706512040509011080           Desired Result          ApplesBananasBananas  Pears    Apples SaleSaleRegular  Regular   RegularTotals210310135  90   80

​Hello, trying to figure out how to use formulas in Excel to process the following data (top rows in table) and get to the desired result (lower rows in table). Any help is much appreciated. Thank you. Data to be filtered and combined        FruitApplesBananasBananasBananasBananasPears Pears BananasApplesApplesSale?SaleSaleRegularRegularSaleRegularRegularSaleSaleRegularNumber?100100706512040509011080           Desired Result          ApplesBananasBananas  Pears    Apples SaleSaleRegular  Regular   RegularTotals210310135  90   80   Read More

​