Compare, Replace values based on Condition

Question

I have this table&nbsp; shown below. I want to group by Site and if SFID is blank for Status Active and SFID is populated for Deselect then the values of SFID, task and Workflow needs to move from row 3 to row 2.&nbsp;Original Data&nbsp;SnoSiteStatusSFIDTypeTaskWorkFlow1Site AnullnullSwift&nbsp;&nbsp;2Site AActivenullSwift&nbsp;&nbsp;3Site ADeselect2929194Retain2INSTALL4Site BnullnullSwift&nbsp;&nbsp;5Site BActivenullSwift&nbsp;&nbsp;6Site BDeselect2928855Retain2INSTALL7Site CActive1234567Retain2INSTALL8Site DActive1235668Swift2INSTALL9Site DDeselect1235639Retain2DAS10Site DActive1278537BH2GUP&nbsp;Result should look like this as belowSnoSiteStatusSFIDTypeTaskWorkFlow1Site AnullnullSwift&nbsp;&nbsp;2Site AActive2929194Swift2INSTALL3Site ADeselectnullRetain&nbsp;&nbsp;4Site BnullnullSwift&nbsp;&nbsp;5Site BActive2928855Swift2INSTALL6Site BDeselectnullRetain&nbsp;&nbsp;7Site CActive1234567Retain2INSTALL8Site DActive1235668Swift2INSTALL9Site DDeselect1235639Retain2DAS10Site DActive1278537BH2GUP&nbsp;Any help is appreciated.&nbsp;Thanks

manjarigoyal1 · Accepted Answer

I found the solution. This video tells exactly what I was looking for.&nbsp;Refer to Previous Row for Subgroups in Power Query - YouTube

Forum Discussion

Compare, Replace values based on Condition

2 Replies

Related content

Conditional Replace Using Outside table

Replace value based on condition from other column

Table Replace Value multiple condition

Replace value in Power Query based on condition

Replace NULL

Sno	Site	Status	SFID	Type	Task	WorkFlow
1	Site A	null	null	Swift
2	Site A	Active	null	Swift
3	Site A	Deselect	2929194	Retain	2	INSTALL
4	Site B	null	null	Swift
5	Site B	Active	null	Swift
6	Site B	Deselect	2928855	Retain	2	INSTALL
7	Site C	Active	1234567	Retain	2	INSTALL
8	Site D	Active	1235668	Swift	2	INSTALL
9	Site D	Deselect	1235639	Retain	2	DAS
10	Site D	Active	1278537	BH	2	GUP