Forum Discussion
Helper IDelete Repeated Headers
Hello -
Anyone know a good way to delete repeated headers that are repeating but not the same? I want to delete row 1-7 but it repeats down the page and the info is different. Also the amount of data will change as well within these headers. I tried transposing but that did not work as the names within 1-7 are not the same. It's always 7 rows of data if that helps.
1 Reply
Maybe add a conditional column based on Column1 where you where you define the row patterns that you want to filter out and assign a 0 to them and then filter the 0's out? That only works however if there is some kind of repeating pattern withing the headers such as starts with "Report No." etcetc. Or even easier, if the data you want always starts with J.D. or a certain amount of spaces you could use that and define a value for all remaining rows ("else" in the conditional column UI) that you want to filter out
