Organizing multiple uses of herbs in an Excel spreadsheet

Hi Jemjem,

You have reached the Apple Numbers forum. This is not an Excel forum.

Welcome!

However, if you are trying to convert an Excel document to Numbers, I strongly suggest that you keep all your data in a single table (not in a huge "Ocean" of a sheet, with "Islands"of data here and there).

Then you can "pull" subsets of data into other tables.

Perhaps you could try this:

More information on your overall aim may lead to a solution.

Happy Numbering 😉!

Regards,

Ian.

You can certainly put multiple 'use' values in the cell, but I don't recommend it.

You can use option-return to create a newline within a cell, like:

Use 1<option-return>
Use 2<option-return>
Use 3

but this will almost certainly cause problems later on when you try to sort, filter, and otherwise categorize the data

For example, it's hard to perform any kind of lookup to find valid herbs for 'Use 2' when that value is buried in the middle of a cell.

Without knowing your designed end goal, it's hard to know if that's a problem, but a better solution may be to put each Use into a separate cell, like:

This way you're not limited to the number of Uses for a given herb.. you can just extend the column downwards, inserting rows as needed.

Now it's easy to filter on Uses and work back to find the relevant herbs (although I'd add a (hidden) middle column to facilitate that). This may or may not be useful to your needs.

Hi Jemjem,

I suggest that you create a table where every row is a complete record.

Something like this:

Then you can sort, filter, show categories or create pivot tables.

Regards,

Ian.