Prepare the data by identifying Partners that are part of "APPLE COMPANY". If a Partner is either iTunes or Apple, it is part of "APPLE COMPANY". . O O In the SALES worksheet. Insert a column to the right of PARTNER NAME, call it APPLE COMPANY Populate the APPLE COMPANY column using a series of nested functions. It can be done several ways. One way is thru a combination of LEFT, OR and IF nested functions. Start by Identifying common characters to the left of Partners values o Then, with the OR function select these partners. Finally wrap it in an IF. If a partner is an Apple Company then "APPLE COMPANY", else leave it blank. Create a column to the right of APPLE COMPANY, call it "PARTNERS AND APPLE GROUPED". Populate this last column with an IF formula. If APPLE COMPANY partner tests TRUE, then "APPLE COMPANY", else the value of the Partner Name. O Prepare the data by identifying Partners that are part of "APPLE COMPANY". If a Partner is either iTunes or Apple, it is part of "APPLE COMPANY". . O O In the SALES worksheet. Insert a column to the right of PARTNER NAME, call it APPLE COMPANY Populate the APPLE COMPANY column using a series of nested functions. It can be done several ways. One way is thru a combination of LEFT, OR and IF nested functions. Start by Identifying common characters to the left of Partners values o Then, with the OR function select these partners. Finally wrap it in an IF. If a partner is an Apple Company then "APPLE COMPANY", else leave it blank. Create a column to the right of APPLE COMPANY, call it "PARTNERS AND APPLE GROUPED". Populate this last column with an IF formula. If APPLE COMPANY partner tests TRUE, then "APPLE COMPANY", else the value of the Partner Name. O