numbers formula problem

I have the following numbers, 20 in total. Numbers are from 0-9.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

3 7 8 1 2 6 6 7 3 1 0 7 0 1 2 2 1 6 8 2

i have another row where I want to put all the numbers that exist in the row 2. numbers that do not appear in that row should not appear in my other row.

But i just want to display the numbers once. The result would be like this:

0 1 2 3 6 7 8

Each number in a different cell.

4,5 and 9 do not appear.

I Hope you could understand my problem. I could post a screenshot, but this forum is buggy.

many thanks,

iMac (27-inch Mid 2011), OS X Mavericks (10.9.5), Pages 5.2.2

Posted on Oct 16, 2014 10:53 AM

18 replies

SGIII

Level 8

37,550 points

Oct 19, 2014 10:54 AM in response to Rubberdonkey

Sorry, but I don't follow... "Reorganize Columns". Where do you see that? Are you using the old Numbers?

Rubberdonkey Author

Level 1

16 points

Oct 19, 2014 10:59 AM in response to SGIII

Transpose Rows and Columns is the right one. Sorry, I have the german version of numbers.

SGIII

Level 8

37,550 points

Oct 19, 2014 11:05 AM in response to Rubberdonkey

Ah, Transpose. I see.

But from the examples you have posted it seems you already have 16 columns, not 5.

Anyway, I would suggest making a copy of your document, and then in the copy, experimenting with Transpose Rows and Columns.

You may find that reorganizing your data will solve some of your problems and overcome some the inherent limitations of spreadsheets.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

numbers formula problem