Quote:

my level of scripting (novice).



Josh,

Unless one of the more advanced scripters here takes it on for you the answer is no. There is no easy built-in method with probably any script language. Can it be done, yes it can be done, but it is not a novice level task.

If someone does decide to help you completely with this task then you will need to be more specific on all the details and show examples. Les asked you a few questions and you only maybe answered one or two.

Please provide all the details asked, also the version of KiXtart you're using.

Will it be done locally on your system or some other system, does it need to be done remotely? What version of Excel?

Please show examples of what is in the columns and what you want removed, etc...