Create a list of unique items from many rows of same data
I have data which is set out in the format below:
Year | Total
2011 | 1000
2011 | 2000
2011 | 2050
2012 | 1000
2012 | 1500
There are many rows per year, and in turn, many years.
What I am looking to achieve is a report which would show one result per year, something like:
Customer | Year2011 | Year 2012 | Year 2013
Bob | Yes | Yes | No
Jill | Yes | Yes | Yes
This would probably be a list layout, but I'm unsure how I get the 'Yes' and 'No' to represent at least one row per year from the source table.
Any help appreciated, thanks