Need macro for copying values from single column and pasting in multiple columns

[moramramesh]

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.

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

 

[moramramesh]

s