I have two sheets, sheet 1 is basically where the raw data is pasted in and sheet2 is the output with the clean data. Both sheets will have the same column headers. I have created a helper column in sheet (column T) that basically indicates the necessary rows with "TRUE" or "FALSE" and I do not want any blank rows in sheet2
What I am basically trying to do is create a formula that will bring the necessary rows to sheet2 only for rows that have "TRUE" in column T of sheet1.
Bookmarks