Moving data in an Excel spreadsheet, will I need to use VBA? If so, how would I go about doing it?
===

as cliche as it sounds, long time reader, first time poster. I'm currently helping a family member out with some work and he has to sort through several thousand records and slightly change the format, obviously without some sort of automation it would take tens of hours and he asked me if I could help do it quickly. At first I thought I could, but I'm a little over my head with some of this stuff.

Basically, he has this data in this type of format:
<pre>
Sample No 
1 Ag 20
1 Au 50
1 Cu 80
2 AG 1
2 Au 30
3 Cu 30

But we need the data like this:

Sample No. Ag Au Cu
1          50 20 80
2          1  30 -
3          -  -  30
</pre>
At first I thought I could do it with a formula to move the data horizontally. The only problem is the missing data would preferably be filled with a '-', but in the original data given they are just left out entirely, so Im assuming I'll need VBA.

Sorry if I left anything out, but any pointers in the right direction with VBA would be incredibly handy.

Thanks