Advanced usage tips for Excel subtotals

Advanced usage tips for Excel subtotals

First, connect the similar terms.

"Example", as shown in the following illustration, requires that the product of the same vendor be connected and displayed in a cell.

Operation Steps

1, copy a data table, select the copied data area-data-subtotals. Modify the summary entry in the Subtotal window to "vendor."

2, c column widening, enough to accommodate the merged string length. then select column C. Start-padding-justify.

3, after the combination of positioning null value, the blank line delete

The effect after the deletion.

(using the Delete duplicate value function, you can get the corresponding supplier name, omitted here)

Merging the same items into cells

"Example 2" borrows the form of Example 1, which requires that the same supply of column A be merged into the same cell.

Operation Steps

1. Select data table Subtotal (same example 1 is also vendor name), complete the rollup, select a column area (A2:A16), ctrl+g Open the positioning window-positioning criteria-null value.

2. After selecting the empty cell, click the cell Merge command in the toolbar.