Table transformation

matal4 try the following

1) Duplicate the tables and call it lets say table2

2) rename primary cost center & primary fte cols to cost center and fte  in orig table

3) delete secondary cost center & secondary fte cols from orig table

4) group by fte by cost center in orig table

5) rename secondary cost center & secondary  fte cols to cost center and fte  in table2

6) delete  primary cost center & primary fte cols from table2

7) group by fte by cost center in table2

8) union these tables which have been grouped by cost center