Enter the background, the commodity file, click on category A first, and all the commodities belonging to category A, settings, batch modification, left side and formula range will be displayed. Select all the rows, right columns to be modified in batch, click the drop-down box, then press F6 to find the commodity category and formula expression, and enter category B in the blank space.

It is suggested that it is best to enter the category code to prevent it from being displayed after modification. Enter the corresponding category on the left side of the commodity file, and the code of this category is in front. For example, the code of Class B is 02, then the formula in the blank space is 02. Note that the quotation marks are in English. Then, apply, confirm and save F6. It's over.