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

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

sd_kevin — Fri, 15 May 2020 18:13:05 GMT

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!

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

camargos88 — Fri, 15 May 2020 19:32:19 GMT

Hi sd_kevin ,

Check this file: Download PBIX

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

sd_kevin — Fri, 15 May 2020 20:05:45 GMT

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

Warm regards,

Kevin