Forum Discussion
Change rows
Hi lucasib ,
Please follow the steps below in Power Query :
1) Select the "Date" column and go to "Transform" --> "Fill" --> "Down"
Repeat this for the "Valor" and "Opercao" columns
This will replace the null values with the last non-null value in the rows above.
2) Select the "NSU" column and click on the filter button. Select "Text Filters" --> "Does not begin with" and add 130 as the value as shown below.
3) All rows starting with 130 will be filtered out and you will get the desired output.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
Solution SageHi lucasib ,
Please follow the steps below in Power Query :
1) Select the "Date" column and go to "Transform" --> "Fill" --> "Down"
Repeat this for the "Valor" and "Opercao" columns
This will replace the null values with the last non-null value in the rows above.
2) Select the "NSU" column and click on the filter button. Select "Text Filters" --> "Does not begin with" and add 130 as the value as shown below.
3) All rows starting with 130 will be filtered out and you will get the desired output.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊