Convert Hierarchy/Group to Table form

Copper Contributor

Hi there, I'm having a hard time to convert this hierarchy/group into table. Below is the original data

 

1.JPG

 

and I'm trying to convert to this type of table

 

 

2.JPG

 

Is there a way that I can achieve this?

1 Reply
click Data>Outline>Subtotal then select remove all