I have a problem with reshaping my data

[Liran Naaman]

Hi everyone!
I have data that after changing it from Long to Wide
looks like this:

ID	Fullscore1	Fullscore2	Fullscore3	Fullscore4
1
1	43.00
1
1
1		53.00
1
1
1			47.00
1
1
1				46.00
1

I need it to look like this:

ID	Fullscore1	Fullscore2	Fullscore3	Fullscore4
1	43	53	47	46
2
3
4

Do you know how can I change it?

[Nick Cox]

That looks more like collapse than reshape.

[William Lisowski]

Welcome to Statalist.

Nick may have better intuition than I do, but you did not show an example of your input data, nor the reshape command you used, and without those I find it difficult to guess how to correct or replace your reshape command to achieve the results you want.

If Nick's suggestion doesn't solve your problem, please take a few moments to review the Statalist FAQ linked to from the top of the page, as well as from the Advice on Posting link on the page you used to create your post. Note especially sections 9-12 on how to best pose your question. It's particularly helpful to copy commands and output from your Stata Results window and paste them into your Statalist post using code delimiters [CODE] and [/CODE], and to use the dataex command to provide sample data, as described in section 12 of the FAQ.

The more you help others understand your problem, the more likely others are to be able to help you solve your problem.