Dear Stata experts,

Here's the sample data

ID Clinical_1 Clinical_2 Clinical_3 Visit_4 Visit_5
1 0 0 1 4 5
2 0 1 1 4 5

reshape long Clinical Visit, i(ID) j(timepoint visit) but this code is not resulting the long format like below

Is there a way to reshape in a long format like the below. Please advise. Thank you so much

ID timepoint Clinical Visit
1 1 0 .
1 2 0 .
1 3 1 .
1 4 . 4
1 5 . 5
2 1 0 .
2 2 1 .
2 3 1 .
2 4 . 4
2 5 . 5