Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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)

Posted on Mar 3, 2014 4:06 PM

Reply
Question marked as Best reply

Posted on Mar 3, 2014 4:57 PM

John,


Is this what you had in mind?

User uploaded file


If you want to Copy and Paste, here are the expressions:


=IF(COUNTIF(A$1:A2, A)=1, MAX(B$1:B1)+1, "")


and


=LOOKUP(COLUMN(), First::$B, First::$A)


Jerry

6 replies

Numbers 2: Create a new header cell, listing once the contents of a column

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.