Hi everyone, I really hope someone can help me with a little problem. It is likely something silly I'm missing, but I need to resolve this issue as soon as possible.

I have a set of data from an external source which populates a sheet via SQL:

ID Date Vex 1 Vex 2 Vex 3 Vex 4 Vex 5
009999 01/01/2014 5 8 22 26 41
009998 01/12/2013 10 11 29 40 47
009997 01/11/2013 30 32 38 41 45

I need to take the row values and group them into set ranges, of 0-9, 10-19, 20-29, 30-39 and 40-49 so that they appear under these headings. What I'm looking to achieve should look like this:

ID Date 0-9 10-19 20-29 30-39 40-49
009999 01/01/2014 5, 8 N/A 22, 26 N/A 41
009998 01/12/2013 N/A 10, 11 29 N/A 40, 47
009997 01/11/2013 N/A N/A N/A 30, 32, 38 41, 45

Any help will be greatly appreciated.