[AccessD] Splitting data from one row into two

Hello, all. I have a problem I hope someone can help me solve. I've got
data in a table that I need to export to Excel and each row needs to be
split into two rows for each EmpID. It's the AwardAmt and the RRC_RRT
data that need to appear on separate rows. Does anyone have any ideas of
how I can accomplish this in either Access or Excel?

Here's how the data is in my table:

EmpID	 PayGroup	 FirstName	 LastName	 AwardAmt
RRC_RRT	 PayrollProcAcct	 EarningsCode	
0007871	 MBB	 	 Luis M	 Alcazar	 50		 24.24
56704	 	C	
0063749	 MBB	 	Kay S	 	Alexander	 25
12.12	 	56703	 	T	

Here's how it needs to be in Excel:

EmpID	 PayGroup	 FirstName	 LastName	 AwardAmt
RRC_RRT	 PayrollProcAcct	 EarningsCode	
0007871	 MBB	 	 Luis M	 Alcazar	 50
56704	 	RRA	
0007871	 MBB	 	 Luis M	 Alcazar	 		24.24
56704		RRC	
0063749	 MBB	 	 Kay S	 	Alexander	 25
56703	 	RRA	
0063749	 MBB	 	 Kay S	 	Alexander
12.12	 	56703	 	RRT	


Thanks!
Nanette