I have a product numbers in a column A like this:
<tbody>
A
1
40
2
42
3
5403
4
9519
</tbody>
Product numbers can be one to four numerals. Each product can have up to 9 sub-codes. For example: 40-1, 42-5, 9519-8.
Can I use a macro to quickly expand this list and give me all the...