List box as table

[jessica_webb]

I have a chart displaying data from each of my fields. It's important that it stays as one single object as it will be used dynamically elsewhere.

'Year' is the key field that I want to show all possible related values for. However, there is no relationship between the other fields at all (at least not one that I want to show).

I've attached an excel doc, in the first tab is the way the data displays at the moment, and in the second tab is how I want it to display.

Basically, I want to remove duplicates and essentially show what would appear in a list box for each field, for each value in 'Year'.

Hope that makes sense! Any help appreciated.

Jess

[jessica_webb]

I thought that was working as it should then, but have just spotted an issue...

Basically, it is just repeating the same values for Y1, 2 and 3.

But not all values are relevant to all  years.

So for example, Section D 'Z68' is relevant to Y2 and Y3, but not Y1, so shouldn't appear under Y1...