Hi All ,
My input is like this .
<tbody>
</tbody>
In this above excel sheet, i need to repeat the values in 1st and 2nd column until the occurrence of a new value.
i.e the output should be like this.
<tbody>
</tbody>
please NOTE: the change needs to only happen in column 1 and 2.
I am beginner in Macros, anybody help with code and its explanation would be much appreciated.
Thanks,
Manvit
My input is like this .
Date | ordernum | Name |
1/2/2019 | A23423 | Alex |
1/2/2019 | B54534 | John |
5/2/2019 | E454 | Joe |
4/2/2019 | C64354 | Ruby |
<tbody>
</tbody>
In this above excel sheet, i need to repeat the values in 1st and 2nd column until the occurrence of a new value.
i.e the output should be like this.
Date | ordernum | Name |
1/2/2019 | A23423 | Alex |
1/2/2019 | A23423 | |
1/2/2019 | A23423 | |
1/2/2019 | A23423 | |
1/2/2019 | B54534 | John |
1/2/2019 | B54534 | |
1/2/2019 | B54534 | |
5/2/2019 | E454 | Joe |
5/2/2019 | E454 | |
4/2/2019 | C64354 | Ruby |
<tbody>
</tbody>
please NOTE: the change needs to only happen in column 1 and 2.
I am beginner in Macros, anybody help with code and its explanation would be much appreciated.
Thanks,
Manvit
Last edited: