Record macro to sort individual columns and remove duplicates and repeat for next column

Good day

I am trying to create a unique list. To achieve this I am copying data into column A. Running a text to columns command to create an unspecified number of columns base on a character such as a semi colon or slash or whatever I choose.

I then want to record a macro that can highlight the selected column, sort it and remove duplicates and move to the adjacent column at the push of the button.

This process must repeat until I have sorted all the columns in order to remove the spaces in between the rows.

After I have cleaned the data as above I want to copy the the column data into the first column and sort it to create a unique list. I can only achieve this easily by removing the blank rows. Each column can be sorted independently from any adjacent column, because the data will be copied and stacked to column A.

My request for help is how do I record the macro to sort each column and move to the next one at the push of a button.

Thank you

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.