Grouping data similar to pivot in Excel

[mlozovskaya]

Looking for help how to group my data similar to excel pivot table functionality where I see one header for each group, and I can expand to see details and collapse for summary view. Please see attached file with input and desired output

[cjaneczko]

Dont believe this functionality exists without triggering a VBA macro in excel with the Run Command tool in Alteryx.

[binu_acs]

@mlozovskaya I don't think you can exactly mimic the excel pivot format in Alteryx but you can create something like below