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.
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.