Remove Range Group

Data > Outline > Ungroup

 

Removes columns (or rows) from the outline from the specified position, and returns them to individual columns (or rows).

 

Dialog box items

Rows:
Choose to ungroup rows.

Columns:
Choose to ungroup columns.