Data separation from single column : I have data in single column like different sets:
Original data
Class: Country1
Object: State1
Description: DEsc1
Object: State2
Description: DEsc2
Object: State3
Description: DEsc3
Object: State4
Description: DEsc4

Class: Country2
Object: State1
Description: DEsc1
Object: State2
Description: DEsc2
Object: State3
Description: DEsc3
Object: State4
Description: DEsc4

Class: Country3
Object: State1
Description: DEsc1
Object: State2
Description: DEsc2
Object: State3
Description: DEsc3
Object: State4
Description: DEsc4

Class: Country4
Object: State1
Description: DEsc1
Object: State2
Description: DEsc2
Object: State3
Description: DEsc3
Object: State4
Description: DEsc4




I am looking for Excel VBA macro code , which will clean and organize my data.

Expected Data		
Class	        Object	  Description
Country1	Object1	  DEsc1
Country1	Object2	  DEsc2
Country1	Object3	  DEsc3
Country1	Object4	  DEsc4
Country2	Object1	  DEsc1
Country2	Object2	  DEsc2
Country2	Object3	  DEsc3
Country2	Object4	  DEsc4
Country3	Object1	  DEsc1
Country3	Object2	  DEsc2
Country3	Object3	  DEsc3
Country3	Object4	  DEsc4
Country4	Object1	  DEsc1
Country4	Object2	  DEsc2
Country4	Object3	  DEsc3
Country4	Object4	  DEsc4