Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
8 years ago
Solved

How to keep rows based on a specified value in a cell and the row immediately below it

 

 

I have a spreadsheet which has data in a specific sequence. Row 15 contains a fixed value-"Detailed Description" and Row 16 contains a variable value "Roof was Damaged". With an increment of 583 the same thing repeats. For example, Row 598 = "Detailed Description" and Row 599 ="Capex", Row 1181 = "Detailed Description" and Row 1182= "AC Equipment" and so one.

 

I am trying to put a filter in this coulmn which would enable me to only get the values of Row 15,16,583,598,1181,1182 and so on. Can it be achieved in Power query?

 

Thank you in advance