When to use a Pivot table and when to use Access?

Hello everyone, this is my first time posting so I hope that my title was OK? My problem is as follows and I would really appreciate any suggestions.

I am organising an event where there are 50 sellers who get assigned a number (1-50). During the sale I will be collecting the sold labels and inputting them to ascertain who has sold what. My question is, what is the best way of doing this i.e. pivot table or Access. I will be inputting the amounts as they are given to me so they won't have been sorted into seller numbers. I thought about having the first column in Excel with numbers 1-50 and then inputting the amounts as they come in into the appropriate row. I will then end up with maybe some seller no's having sold 40 items and therefore populating 40 columns. I will then want to extract this information to show the totals against the seller numbers so that I can then calculate a certain percentage of the total. I've tried to explain the best I can and I hope it makes sense!? Can anyone give me some advice. Many thanks

Jeff, thank you so much for replying.

How would that work if, for example, the sheet would look like below (sorry can't seem to insert a table!!!)

Seller Number Item Amount Amount Amount Amount Amount
45 Blip £12.50 £2.50 £0.50
17 Flap £121.00
32 Droop £32.00 £2.00
12 Cleep £37.00 £1.00 £1.00 £1.00 £0.50

Does that make sense?

Thanks Marvin, just one last thing... sorry... I don't actually have to note what the item is so I only really need to know the seller number and the amount. It would be helpful to know who the seller was but not essential as I will have that on another sheet with other details. Presumably, if I input as you have described above, I could then sort them in seller number and then autosum?

Yes, that could work also.

The key thing is that the way that you initially proposed to organize your data makes any kind of analysis darn near impossible. Change to one transaction per row and you have lots of possibilities.