Hello,
This is my first time posting here so pardon me if my post didn't follow the forum format.

I'm working with a dataset as shown by the example below.

Year ID State Sex Co2 CH4 MinTemp Distance
2005 101 Florida Male ;0.3;0.3;0.4;0.3;0.2;0.3 ;38;33;;;; ;;;;;; 0.67
2005 102 Alabama Male ;0.3;0.4;0.4;0.2;0.2;0.4 ;39;39;39;40;43;43 ;;;;;; 32
2005 103 Florida Female ;0.3;0.3;0.3;0.3;0.2;0.4 ;40;40;39;40;43;43 ;;;;;; 32
2005 104 Alabama Female ;0.3;0.3;0.4;0.3;0.2;0.6 ;;;40;40;43;42 ;;;;;; 0.42
2005 105 Alabama Female ;0.3;0.3;0.4;0.3;0.2;0.1 ;35;34;38;34;;; 3.5;3.7;5.1;3.9;0.6;-1.5 1

Most of the variables I'm interested in (Co2, Ch4, MinTemp) have a number of values in the same cell delimited by semicolons. I tried using the "Split" command but didn't get results as I want. I want the my final dataset to resemble a panel dataset as shown below. Any help will be greatly appreciated.

Year ID State Male Co2 CH4 MinTemp Distance
25/04/2005 101 Florida Male 0.3 39 0.67
26/04/2005 Male 0.3 33
27/04/2005 Male 0.4
28/04/2005 Male 0.3
29/04/2005 Male 0.2
30/04/2005 Male 0.3
25/04/2005 102 Alabama Male 0.3 39 32
26/04/2005 Male 0.4 39
27/04/2005 Male 0.4 39
28/04/2005 Male 0.2 40
29/04/2005 Male 0.2 43
30/04/2005 Male 0.4 43