Insert New Rows (a Subtotal Row and Repeating Header Row)

[chalter]

Hello,

I have raw data that shows the count of items by person's name. My goal is to insert new rows (a subtotal row after each person's name and a repeating header row right below the subtotal). What formula/Alteryx tools should I use?

Raw DataGoal - Insert New Rows (highlighted in yellow) (subtotal row and repeating header row)

Thanks!

[MilindG]

@chalter 

[chalter]

Thanks! Do you know how to add another row to repeat the "item 1, item 2, item 3" header?

[cjaneczko]

This is messy but provides the output you are looking for.