Convert Hierarchy/Group to Table form

%3CLINGO-SUB%20id%3D%22lingo-sub-2295968%22%20slang%3D%22en-US%22%3EConvert%20Hierarchy%2FGroup%20to%20Table%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2295968%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20I'm%20having%20a%20hard%20time%20to%20convert%20this%20hierarchy%2Fgroup%20into%20table.%20Below%20is%20the%20original%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.JPG%22%20style%3D%22width%3A%20883px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275705i22ABC03C3DC8B7C9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.JPG%22%20alt%3D%221.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20I'm%20trying%20to%20convert%20to%20this%20type%20of%20table%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275706i5519B0D69D7017F2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222.JPG%22%20alt%3D%222.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20that%20I%20can%20achieve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2295968%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356689%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20Hierarchy%2FGroup%20to%20Table%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356689%22%20slang%3D%22en-US%22%3Eclick%20Data%26gt%3BOutline%26gt%3BSubtotal%20then%20select%20remove%20all%3C%2FLINGO-BODY%3E
Occasional Visitor

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