Pivot Table extraction Non-Repeated Records (1)-value displayed

Pivot Table extraction Non-Repeated Records (1)-value displayed

Key design points: non-repetition and pivot tables

Ajin: Actually, there is still a way to extract non-Repeated Records.

Xiuxiu: What?

Ajin: PivotTable.

Xiuxiu: Is it a PivotTable again?

Ajin: Yes. Create a PivotTable and place all fields that do not want to be repeated in the row area, such as "Item Name". In this way, you can obtain the unique value of the name that appears.

Xiuxiu: Oh? It's also quite simple. What if I want to find all the categories of each item?

Ajin: Think about it yourself?

Xiuxiu: Hum! Take another one ......