Hi Excel Guru's
I'm hoping one of you can help me with a macro in Excel 2007.
I have a row of data as follows on 'sheet1' with the word 'Dog' starting in cell A1.
<tbody>
</tbody>
What I am after is a macro that will on 'sheet2' list the data as shown below. I want the word to appear the number of times based on the value below it.
<tbody>
</tbody>
Any assistance would be greatly appreciated.
Gareth
I'm hoping one of you can help me with a macro in Excel 2007.
I have a row of data as follows on 'sheet1' with the word 'Dog' starting in cell A1.
A | B | C | |
1 | Dog | Cat | Bird |
2 | 1 | 2 | 3 |
<tbody>
</tbody>
What I am after is a macro that will on 'sheet2' list the data as shown below. I want the word to appear the number of times based on the value below it.
A | |
1 | Dog |
2 | Cat |
3 | Cat |
4 | Bird |
5 | Bird |
6 | Bird |
7 | Bird |
<tbody>
</tbody>
Any assistance would be greatly appreciated.
Gareth