I want to be able to build a list of column headings automatically from a list of information.

My workbook contains data imported from XML. several of the sheets contain repeating info for certain vaules and im trying to consolidate the information into one table.

Essentially i need to search a column, return only the unique values and then transpose the information into column headings in a new sheet.