Create a dynamic header list in excel

Create a horizontal header based on a vertical column that changes when you edit the column.