Best way to represent list of values of some type

[EmilyGraceSeville7cf]

Hi! What is the best way to represent a value list of some type in a spreadsheet editor? For instance, I would love to track the food I buy and the time when it happens. IOW, I have two columns: Date and Product list. I thought about listing products via comma like: cheese, bread:

But is there a better way to do that not to split then everything by coma to handle (to make a graphic representing how often I buy each type of product for instance)?

I’m a beginner in spreadsheet editor, so any help will be appreciated.

[DavidRGreen]

Hi @EmilyGraceSeville7cf
While a comma delimited list may be usable, it might be a problematic data format to manipulate easily via a spreadsheet.

The first thing that came to mind was orienting the data in to 2 columns, date and product, with one product per row.
And then Pivoting that data into a summary.

The Product and Date form the grouping rows, and Count of Product does the tally.

… Maybe someone will have another idea, perhaps using comma delimited data.