Apple Numbers Formula
I am trying to create a table where only unique values from a particular row of existing table are presented in the row of new table. Which formula can I apply?
MacBook Pro (2021)
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am trying to create a table where only unique values from a particular row of existing table are presented in the row of new table. Which formula can I apply?
MacBook Pro (2021)
Can you give an example?
There are several ways of doing this, but my first thought goes to a pivot table, which will automatically filter and organize a table. Without knowing the source of the data, though, it's hard to know if that's appropriate here.
Apple Numbers Formula