smreinholtz
New Member
- Joined
- Jul 10, 2014
- Messages
- 11
Hello,
I have a macro request that may be difficult but I hope you are up for the challenge
I have a group of data that looks like this:
<tbody>
</tbody>
As you can see, I the first column contains material numbers, while the second contains revision letters. What I need to do create a new row for each missing letter, stopping at the end of the material number group. So this previous data would become:
<tbody>
</tbody>
Any thoughts? Thanks in advanced for you help!
I have a macro request that may be difficult but I hope you are up for the challenge
I have a group of data that looks like this:
30004 | A |
30004 | B |
59684-1 | B |
59684-1 | C |
85201 | A |
85201 | C |
85201 | D |
85201 | E |
30898 | A |
30899 | A |
<tbody>
</tbody>
As you can see, I the first column contains material numbers, while the second contains revision letters. What I need to do create a new row for each missing letter, stopping at the end of the material number group. So this previous data would become:
30004 | A |
30004 | B |
A | |
59684-1 | B |
59684-1 | C |
85201 | A |
B | |
85201 | C |
85201 | D |
85201 | E |
30899 | A |
30899 | A |
<tbody>
</tbody>
Any thoughts? Thanks in advanced for you help!