Hello
I have a spreadsheet like the below
<tbody>
</tbody><colgroup><col><col span="3"></colgroup>
I would like a macro to copy and separate the 3 dates on each row to end up like the below
<tbody>
</tbody><colgroup><col><col span="3"></colgroup>
The actual spreadsheet is much longer so to do this manually will take a long time!
Any help would be appreciated.
Thanks
Stewart
I have a spreadsheet like the below
Name | Date 1 | Date 2 | Date 3 |
X | 20/04/2013 | 21/04/2013 | 22/04/2013 |
Y | 21/05/2013 | 22/05/2013 | 23/05/2013 |
Z | 22/06/2013 | 23/06/2013 | 24/06/2013 |
<tbody>
</tbody><colgroup><col><col span="3"></colgroup>
I would like a macro to copy and separate the 3 dates on each row to end up like the below
Name | Date 1 | Date 2 | Date 3 |
X | 20/04/2013 | ||
X | 21/04/2013 | ||
X | 22/04/2013 | ||
Y | 21/05/2013 | ||
Y | 22/04/2013 | ||
Y | 23/04/2013 | ||
Z | 22/06/2013 | ||
Z | 23/04/2013 | ||
Z | 24/04/2013 |
<tbody>
</tbody><colgroup><col><col span="3"></colgroup>
The actual spreadsheet is much longer so to do this manually will take a long time!
Any help would be appreciated.
Thanks
Stewart