I think that using an array formula will solve my little problem, but I only
understand a little about them, and the formulae are only returning blanks.

I have a table of data, that I wish to rearrange into a grid based on
entries into 2 columns with restricted values allowed.

The data is in the format, and the headers define the Named Ranges
ID# Description Y-axis X-axis
-------------------------------------------
01 Apples A Left
02 Oranges B Left
03 Bread C Center
04 Table B Right
05 Desk C Center
......

The description column is not to be returned, but I have included it in case
it requires a different solution.

I have then entered formula similar to the following in a grid
{=Concatenate(If(and(Y-Axis=C,X-Axis=Center),Text(ID#," 00,"),""))}
and was expecting it to return the result, " 03, 05,"

so the complete grid would like

| Left | Center | Right |
--|---------|-------------|---------|
A | 01, | | |
--|---------|-------------|---------|
B | 02, | | 04, |
--|---------|-------------|---------|
C | | 03, 05, | |
--|---------|-------------|---------|

Could someone let me know why this isnt working, or some other way in which
it can be achieved

Thanks very much in advance

Kris