I have a table where I need to delete all the columns that contain the word "status" or "associated" in the header. How do I do this?
@richleeb2 Try this:
Hi,
I tried this but the output formatting came out wrong. My original table has 11 records and 1093 columns.
use dynamic select toolyou can refer to the example attached.
Dynamic select >- select by formula!Contains([Name],"status") or !Contains([Name],"associated")