Grouping Row Values Based On Set Criteria

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.

hi RRa, option, please check attachment, press "Run" button or run code "test"

hi RRa, yes, it is possible, can you provide a sample workbook with target sheet for result table?

Originally Posted by watersev

hi RRa, yes, it is possible, can you provide a sample workbook with target sheet for result table?

Hi watersev, thanks for the reply and sorry for the delay in getting back.

I can't provide a direct copy of the original spreadsheet, but I have modified the one you provided previously to reflect the general aim:

1. Click on Run
2. All results in the Data sheet are evaluated and grouped based on criteria
3. The grouped values are displayed in the GroupTblAlpha table in the Grouping sheet
4. When Run is clicked again, the same process is executed overwriting the values present in GroupTblAlpha (this is to maintain the order and prevent duplication when new data is parsed into the Data sheet)

Thank you for your on-going support and I look forward to your reply.

hi RRa, please check attachment, click Run

Thank you for all of your help watersev, it is working well and doing everything required.