Forum

Power Query - Remov...
 
Notifications
Clear all

Power Query - Remove extra rows from a table

3 Posts
2 Users
0 Reactions
58 Views
(@cbenitez)
Posts: 45
Trusted Member
Topic starter
 

Hi,

Is there a way to remove extra rows, at the bottom of a table, when refreshing a query?

So when the query refreshes, extra rows do not appear?

Please advise.

Cele

 
Posted : 24/06/2017 3:22 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Celeste,

Have you tried 'Remove Blank Rows' on the Home tab of the Power Query editor?

Mynda

 
Posted : 25/06/2017 2:26 am
(@cbenitez)
Posts: 45
Trusted Member
Topic starter
 

How did i miss that ? EmbarassedSmile

Thank you

 
Posted : 27/06/2017 7:15 am
Share: