Question

/*Question 4: A doctor examines the growth of three kids. The following data is a record of those kids hight (meter) and weight (kg) collected at five different times. The first column is the ID of kids, the next five columns are the hight of kids, and the last five columns are the weight of kids. Please transform the data such that each kid has five observations and five columns showing, repectively, ID, time of measurement, height, weight, and BMI index. BMI is calculated as weight divided by the square of height. 1 0.9072 1.0080 1.1592 1.3356 1.5372 21.4545 26.9091 29.5455 36.2727 45.4545 2 0.7560 0.8316 0.9576 1.1088 1.2348 15.9091 18.1818 21.3636 25.4545 32.2727 3 0.8316 0.9324 1.1088 1.2348 1.3608 19.5455 27.2727 32.7273 39.5455 52.2727 */

Answer 1

ID	Time	Height	Weight	BMI
1	1	0.9072	21.4545	26.06828
2	1	0.756	15.9091	27.83569
3	1	0.8316	19.5455	28.26297
1	2	1.008	26.9091	26.48367
2	2	0.8316	18.1818	26.29105
3	2	0.9324	27.2727	31.37066
1	3	1.1592	29.5455	21.98744
2	3	0.9576	21.3636	23.29733
3	3	1.1088	32.7273	26.61974
1	4	1.3356	36.2727	20.3342
2	4	1.1088	25.4545	20.70418
3	4	1.2348	39.5455	25.93605
1	5	1.5372	45.4545	19.23606
2	5	1.2348	32.2727	21.16616
3	5	1.3608	52.2727	28.2284