bigdatahelp.jpg

Hi forum!

Example attached - want to go 'from this to this' using either Pivot table or creating a database (I'm not too knowledgeable on this but can learn with some direction).

If this was a one off with small amounts of data, ordinarily I would follow the steps of 1) Insert Column, 2) copy and paste A>F below original 3) copy data in H below original etc. etc. but as this involves many many cells and will be frequent, I need to learn a more efficient way.

Appreciate all of your help in advance.