Install

Functions

Blog

Pricing

About

back

SheetFlash Functions

File Processing

Merge Files

Split File

Text Extraction

Extract Segmented Strings

Extract Words

Extract by Regex

AI

Generative AI

Sheet Processing

Merge Sheets

Add Sheets

Delete Sheets

Data Analysis

Countifs

Sumifs

Date and Time

Convert Number to Date

Basic

Text

Copy and Paste

Clear

Native Formulas

Insert Rows/Columns

Delete Rows/Columns

Table Manipulation

Collapse Hierachical Categories

Deduplicate

Expand

Fill Empty

Filter

Group

Sort

Text Processing

Insert Letters

Join Texts

Replace Words

Replace by Regex

Sort Letters

Trim

Join / Lookup

Lookup

Join Tables

SheetFlash Functions

File Processing

Merge Files

Split File

Text Extraction

Extract Segmented Strings

Extract Words

Extract by Regex

AI

Generative AI

Sheet Processing

Merge Sheets

Add Sheets

Delete Sheets

Data Analysis

Countifs

Sumifs

Date and Time

Convert Number to Date

Basic

Text

Copy and Paste

Clear

Native Formulas

Insert Rows/Columns

Delete Rows/Columns

Table Manipulation

Collapse Hierachical Categories

Deduplicate

Expand

Fill Empty

Filter

Group

Sort

Text Processing

Insert Letters

Join Texts

Replace Words

Replace by Regex

Sort Letters

Trim

Join / Lookup

Lookup

Join Tables

SheetFlash Functions

File Processing

Merge Files

Split File

Text Extraction

Extract Segmented Strings

Extract Words

Extract by Regex

AI

Generative AI

Sheet Processing

Merge Sheets

Add Sheets

Delete Sheets

Data Analysis

Countifs

Sumifs

Date and Time

Convert Number to Date

Basic

Text

Copy and Paste

Clear

Native Formulas

Insert Rows/Columns

Delete Rows/Columns

Table Manipulation

Collapse Hierachical Categories

Deduplicate

Expand

Fill Empty

Filter

Group

Sort

Text Processing

Insert Letters

Join Texts

Replace Words

Replace by Regex

Sort Letters

Trim

Join / Lookup

Lookup

Join Tables

Collapse Hierachical Categories

Updated at:

Feb 3, 2025

Category:

Table Manipulation

The Collapse Hierarchical Categories feature cleans up duplicate data within hierarchical structures in Excel. Even without converting the data into a chart, it enhances the visibility of the hierarchical structure.

See it in Action

Requirements

Data

Target Data
- Data Range: Identify the cells range where you want to apply the function.

Result Destination

Specify the starting cell where the results will be placed.