Numbers 2: Create a new header cell, listing once the contents of a column
Not sure how to search for this question, and moreover I rather think that what I want might not be possible, but just in case I am asking it here.
I am looking for a way to create a new table where its headers will get their contents from the content of a column of another table, without duplicates though.
Example, the content of my column in Table A is listing countries codes.
FRA, GER, ITA, ITA, USA, FRA, UK, CA, FRA, FRA, USA, FRA, GER, FRA, USA, BRA, ITA, USA, UK etc.
What I want is a way to fetch a country code, if it is appearing just once, and create a second table (Table B), with headers the countries code.
So based on the above data, I should come with a table with 7 columns and headers:
FRA | GER | ITA | USA | UK | BRA | CA
Would something like this be ever possible with Numbers ?
(*Numbers 09, if that make any difference)