moramramesh
New Member
- Joined
- May 22, 2019
- Messages
- 17
Hi All,
I need macro for the below task.
I need to copy each set of data under each header from column B to column D, column E, and so on.
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Target state (I want the above values from col B to be pasted to col D, col E etc in horizontal direction to plot the graph):
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
Note: There are empty rows between server names and headers. Also there are empty rows between values and server names
I need macro for the below task.
I need to copy each set of data under each header from column B to column D, column E, and so on.
Column A | Column B |
Server1 | |
Header1 | Header2 |
Date1 | Value1 |
Date2 | Value2 |
Date3 | Value3 |
Date4 | Value4 |
Server2 | |
Header1 | Header2 |
Date1 | Value1 |
Date2 | Value2 |
Date3 | Value3 |
Date4 | Value4 |
Server3 | |
Header1 | Header2 |
Server4 | |
Header1 | Header2 |
Date1 | Value1 |
Date2 | Value2 |
Date3 | Value3 |
Date4 | Value4 |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Target state (I want the above values from col B to be pasted to col D, col E etc in horizontal direction to plot the graph):
Column D | Column E | Column F | Column G |
Header2 | Header2 | Header2 | Header2 |
Value1 | Value1 | Value1 | |
Value2 | Value2 | Value2 | |
Value3 | Value3 | Value3 | |
Value4 | Value4 | Value4 |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
Note: There are empty rows between server names and headers. Also there are empty rows between values and server names