Deleting Cells in Stata: My data looks like "steps"

[Oliver Spicer]

Hi,

First timer here though I have used STATA for quite a while, I have ran into a problem I cannot figure out. I would like to collapse the dataset I am working with so that Table 1 can be transformed into Table 2. I am all out of ideas (have tried merge, collapse, reshape....can't figure this one out).

Any advice?

Thank you!

Cheers,
Oliver

Table 1

Country	Var1	Var2	Var3	Var4	Var5	Var6
Argentina	data
Argentina		data
Argentina			data
Argentina				data
Argentina					data
Argentina						data
Belgium	data
Belgium		data
Belgium			data
Belgium				data
Belgium					data
Belgium						data
Canada	data
Canada		data
Canada			data
Canada				data
Canada					data
Canada						data
.....other countries

Table 2

Country	var1	var2	var3	var4	var5	var6
Argentina	data	data	data	data	data	data
Belgium	data	data	data	data	data	data
Canada	data	data	data	data	data	data
...other countires	data	data	data	data	data	data

[Clyde Schechter]

Duplicate post. Asked and answered at https://www.statalist.org/forums/for...oks-like-steps.