Hi

I've received data from an external source, which is in a summarised format. I need a way to disaggregate this to fit into a system I am using.

To illustrate, suppose the data I received looks like this:

receivedTable:

Age     Gender     Count
40      M          3
41      M          2

I want this is a disaggregated format like this:

systemTable:

ID      Age        Gender
1       40         M          
2       40         M 
3       40         M 
4       41         M          
5       41         M 

Thanks
Karl