Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
70
Views
Topic starter
Hi there,
is there a way to remove repeating column headers in rows by something other than the Date column. My data does not include a date. What else would work to cause and error and remove the rows?
Thanks in advance,
Karen
Posted : 16/06/2018 3:47 pm
Hi Karen,
You can just filter out the header rows by deselecting them in the filter drop down.
Mynda
Posted : 17/06/2018 12:49 am
Hi Karen,
You can try the column filter, to set a text filter, to filter out values from that column equal to "Column Name".
Posted : 17/06/2018 12:52 am
Topic starter
Mynda and Catalin,
thank you so much for your responses. not sure why I didn't think of it but you guys are on point.
Thanks,
Karen
Posted : 17/06/2018 1:21 pm
