Forum Discussion
smpa01
Community Champion
8 years agoHow 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
here is link to pbix, tweak as you feel fit, it is an idea.