Split Number Ranges(001-055) from a Group

[norriz]

I have table with a range of numbers with the associated name(below), need to find a way to split ex:001-005 to 001 and table1, 002 and table1, 003 and table1. Can this be done in access or excel. Help needed urgently. Thank you

Number	Name
001-005	table1
006-010	table2

 

[alansidman]

Can you supply more examples and a mocked up solution. I don't understand what you want. A more detailed explanation will also help.

 

[norriz]

Current State

001-999	tables
301-303, 311, 399	chairs

Future state

001	tables
002	tables
301	chairs
302	chairs

 

[JonXL]

Do you only want the first two from each or would you also want 002 - table, 003 - table, etc. up to 099?

 

[alansidman]

duplicate post: Split ranges(001-005) but keep the associated column

 

[Peter_SSs]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.

 

[Peter_SSs]

I have re-opened this thread since you are looking for either Excel or Access responses. That means this comes under rule #13 (instead of #12) which requires that it is pointed out that the question is cross-posted and links provided. here is the link: Split ranges(001-005) but keep the associated column

 

[Micron]

I've read both threads more than once. I still don't get it in either one of them and have to wonder why it is so hard to post a sample output instead of describing it. This is the way I interpret it, but am probably wrong:

Number	Name
001-005	t1
006-010	t2
1	t1
2	t1
3	t1
4	t1
5	t1
6	t2
7	t2
8	t2
9	t2
10	t2