My home banking App can export to Numbers. It will give me a table with date, category, description and amount. I want to extract all the categories automatically in a second sheet. How can I do this?

Example screen:

enter image description here


I can't do it in Numbers. Numbers has some interesting layout tools,but its utterly pathetic for anything signficant.

If you export as an excel sheet, save to google drive, then open in google sheets it's easy.

Cut and paste seems to work between Numbers and Google sheets too. Values only, AFAIK.

To get a list of unique categories: In Sheet 2 enter the following formula at the top of the column: =Unique(sort(Sheet1!B:B)) This will autofill down. Now if you want them as columns instead:

Create a third sheet. in A1 enter the formula =Transpose(Sheet1:A:A)

If this happens a lot, leave it in place.

If it's a oneshot, then select, copy, paste special, paste values only.

  • Good answer. What I ended up doing: pbpaste | sort | uniq | grep -v Category | pbcopy. copying the whole category column and running that in the shell – Arne Jan 23 '17 at 5:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .