I am a little stuck right now, I know there has to be an easy way to do this, but I'm a little out of practice with my VBA, and developing Macros. I was hoping that utilizing Pivot Tables would get me the information I need in the format I would like it, but unfortunately it didn't do what I am looking for. I have a spreadsheet with what I have reduced to 2 columns. Column A has a list of Assembly Numbers, and Column B has a list of Part Numbers used in those assemblies. I want to take column A and remove the duplicates, and take the information in column B and have the Part Numbers that are associated with the assembly "transposed" into the row that lists the assembly.