Power Query, Pivot every alternate row

[chriscorpion786]

Hi ,
In the custom column, I have store names and every alternate row contains the word T&F, I need to pivot the rows where T&F along with the "Yes/No" in the value column.

The end result should read:

Custom	Value	T&F
Dubai Mall-DM1-1404	Yes	No

Much appreciated for a solution in Power Query, file is attached.

Thanks,
Mustafa

 

[chriscorpion786]

Hi ,
In the custom column, I have store names and every alternate row contains the word T&F, I need to pivot the rows where T&F along with the "Yes/No" in the value column.

The end result should read:

Custom	Value	T&F
Dubai Mall-DM1-1404	Yes	No

View attachment 90375
Much appreciated for a solution in Power Query, file is attached.

Thanks,
Mustafa

 

[chriscorpion786]

By the way, I have posted the same question in Mr.Excel forum as per the link below:

Power Query , pivot every alternate row

Hi All, I have store names and every alternate row contains the word T&F. I need to pivot every alternate row which contains T&F along with the value "Yes/No" in the adjacent column. The end result show look like the below table: CustomValueT&F Dubai Mall-DM1-1404YesNo DCC -...

www.mrexcel.com

 

[Frank2021]

Hi,

Here you are

If you like it, don't forget to click the thumbs up