I need a macro that imports a text file, deletes entire rows if in column C
there is a blank, deletes entire rows that include text that I specify,
concatenates rows that meet criteria (e.g. C1 and C2 are combined if A2="" if
not then C1), and Deletes rows where cells in Column A are blank. I need it
to do this in the order given. Thanks so much for your help and time.