I have uploaded the txt file since format is not fitting here.

I have a table called xyz and it has two colums called QU and collectionID			
The data is stored in the table is like Scenario 1 but I want to extract the data to look like Scenario 2	



Scenario 1

QU	                        	CollectionID

Blade: qcusrea11 / NOB1
	          	null
null	                          	SMRE11		
null	 				SMRE21		
null	 				SMRE31		
null	 				SMRE41		
Blade: qcusrea12 / NOB2
	          	null
null	 				SMRE11		
null	 				SMRE21		
null	 				SMRE31		
null	 				SMRE41		
Blade: qcusred11 / ADC1
	           	null
null	 				SMREM1		
null	 				SMREN1		
null	 				SMREP1		
null	 				SMREQ1		
	

Scenario 2
	
QU					CollectionID	
Blade: qcusrea11 / NOB1
	 		SMRE11		
Blade: qcusrea11 / NOB1
	 		SMRE21		
Blade: qcusrea11 / NOB1
	 		SMRE31		
Blade: qcusrea11 / NOB1
	 		SMRE41		
Blade: qcusrea12 / NOB2
	 		SMRE11		
Blade: qcusrea12 / NOB2
	 		SMRE21		
Blade: qcusrea12 / NOB2
	 		SMRE31		
Blade: qcusrea12 / NOB2
	 		SMRE41		
Blade: qcusred11 / ADC1
	 		SMREM1		
Blade: qcusred11 / ADC1
	 		SMREN1		
Blade: qcusred11 / ADC1
	 		SMREP1		
Blade: qcusred11 / ADC1
	 		SMREQ1