Microsoft Excel 2007 Macros

Excel 2007 - How to find duplicate data and sort into a row

I have two column. I would like to find the duplicate data and sort the int a row. Eg: Name Name2 Julie Jane Sally John Jack Paul Jane Sally The result: Name Name Julie Sally Sally Jack Jane Jane John Paul Pls help

Excel macros not working in password protected workbook

Excel 2007 .... macros work perfectly in original workbook however when i save as and create apassword to open the workbook, it opens OK but the macros don't work. The excel options have the macros enabled but they are deactivated somehow