consolidating data

[JasonHopkins]

Basically, I have a list of data listing spend for different financial years. There are around 4,000 lines set out as per below (example of one supplier) :

Supplier No Supplier Year Total Net No
aae327 A A Engineering & Hydraulics Ltd 2010 £420.00 267
aae327 A A Engineering & Hydraulics Ltd 2011 £455.20 347
aae327 A A Engineering & Hydraulics Ltd 2012 £302.22 137

As you can see they are set out over three lines for each financial year. It would be great if I could have just one line with results set out as below:

Supplier No Supplier Name 2010 2011 2012
aae327 A A Engineering & Hydraulics Ltd £420.00 £455.20 £302.22
dfsdf Abp Marine Enviroment Research £0.00 £0.00 £302.22
accor123 Accor £0.00 £507.65 £3,022.22

I really have no idea how to get around this so any imput would be brilliant. I have attached a rough example of the sheet.

Many thanks
Jason

[modytrane]

see attached sample.
Click the "Update" button and it will create your list on Sheet2.
Does that help?
modytrane

[JasonHopkins]

It won't let me update and is saying its read only when I click the update button?
Thanks
Jason

[modytrane]

try this. It should work.
modytrane