Is it possible to grab a sub group title in the same column as item name and move to its own column?

[sd_kevin]

HI, 

I was wondering if there is a way to grab the Sub Group titles and move them to its own column.  The use case is that we have reports that contain the sub-group and the item name in the same column.  The items are the same in each sub-group so it is difficult to distingish Item "A" from Sub Group 1 vs item "A" from Sub Group 2.  Please see images below.

Raw Data:

ITEM	AMOUNT
Sub Group 1
A	10
B	20
Sub Group 2
A	30
B	40

Desired Result:

Sub Group	Item	Amount
Sub Group 1	A	10
Sub Group 1	B	20
Sub Group 2	A	30
Sub Group 2	B	40

Thank you!

[camargos88 · Accepted solution]

Hi @sd_kevin ,

Check this file: Download PBIX 

[sd_kevin]

Thank you so much Richardo!  That worked like a charm!

Warm regards,

Kevin