Column headers from variety of specific text in column on another sheet?

[dobby1303]

Is it possible to create a set of column headers using text from a column?

I'm not looking for just a simple pivot, I'd like to filter so only one of each text value appears at the top of the column.
For example, if I have:

A
B
C
D
A
A
B

I'd like it to produce:

A B C D


The other thing I'm trying to do is have it so it's dynamic, so that if the values in the original column changes, it adds additional columns at the end of the table.

I have no idea where I'd even start with trying to do something like this.

 

[Eric W]

If your range is A2:A10, and you want the headers to be in C1, D1, E1, etc. then put this formula in C1:

=IFERROR(INDEX($A$2:$A$10,SMALL(IF($A$2:$A$10<>"",IF(MATCH($A$2:$A$10,$A$2:$A$10,0)=ROW($A$2:$A$10)-ROW($A$2)+1,ROW($A$2:$A$10)-ROW($A$2)+1)),COLUMNS($C$1:C$1))),"")

change the ranges to match your sheet, and confirm with Control+Shift+Enter. Drag to the right as far as needed. They will come out in the order they appear.

Hope this helps.

 

[dobby1303]

Thank you!

All working now!

 

[Eric W]

Happy to help!