Moving data from one worksheet to another
 

I am trying to move data from one worksheet to another - Data Sheet

CC Description M
S O L
010000 Labor
Summary
5,000
011700
Burden
1000
020000 Site Work 2000
3000
030000 Concrete
5000 500
040000 Masonry
160000 Electrical
10000


This is how I want the result to look - Summary Sheet

Cost Code CT Description
Amount
010000 L Labor Summary
5000
011700 O
Burden 1000
020000 M Site Work
2000
020000 S Site
Work 3000
030000 M
Concrete 5000
030000 O
Concrete 500
160000 S
Electrical 10000

Basically it moves only lines with data (040000 Masonry does not have
an amount on the data sheet so it does not move to the summary
sheet). If a cost code (row) has multiple entries it moves to the
summary sheet on two rows with the associated description (Site Work,
Concrete). Hope I have explained my problem ok. This is my first
post, I have looked at several posts and nothing quite fits what I
need. Any help would be greatly appreciated.