Dynamic column headings

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.

Use the Data > Advanced Filter to copy the UNIQUE values to another location, then transpose the result into your final needed location. Use the macro recorder to get the base code you can then adapt into your permanent reusable macro.