Replacing a list of values in just one column with certain text

I am creating a template for formatting data that I download from a wholesaler to upload to a platform.
The large database of around 1300 records that comes with category and subcategory names, among all the rest of the data, that I download
There are more column titles and information than I need, so my template will have blank headings that I will know to simply delete after I paste. Maybe there is a Macro for that too.
The category and subcategory names to appear in certain columns. I want those names to appear in multiple columns within the same records. It's embarrassing, but I have not even been able to figure out how to create a formula/macro to copy all of the data in one column to a different column with a different heading and keep those headings different and save them within my template.
I have a list of the 240 with CategoryID, ParentID, Category and Subcategory all corresponding. These always come and go in CSV format, so I cannot create additional sheets to save within my template without a hassle.
In two ID number value columns, I would like all of the text names replaced with corresponding numbers for upload to the platform that requires them.
I have been trying to figure out the best way to create a macro to save within my template for daily use, but so far I have not been able to figure it out. I have been watching videos on vlookup, index & match, find & replace...I have not seen what I need just yet

OK, SO HERE IS MY PRODUCT TEMPLATE SO FAR: https://drive.google.com/file/d/0B5F...it?usp=sharing