How to convert the data into this looking?

[Feyng819]

My original data look like this:
var1 var2 var3
1 3 C

And I want to make them look like this (splitting one row of data into four rows, var2 goes under var1, the value of var1 shows one row of data with var3 and one row of data without var3)
var1 var2 var3
1 . .
1 . C
3 . .
3 . C

Thank you!!

[Reeza · Accepted solution]

The term is TRANSPOSE

Transposing data tutorials:
Long to Wide:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/

Wide to Long:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/

---

@Feyng819 wrote:
My original data look like this:
var1 var2 var3
1 3 C

And I want to make them look like this (splitting one row of data into four rows, var2 goes under var1, the value of var1 shows one row of data with var3 and one row of data without var3)
var1 var2 var3
1 . .
1 . C
3 . .
3 . C

Thank you!!

---

[Feyng819]

Thank you for your help! I would like to ask that how can I get the alternative var3 value? And i tried to use transpose and my data look like
1
3
C
Im not sure if I am using the transpose correctly

[Reeza]

---

@Feyng819 wrote:

Im not sure if I am using the transpose correctly

---

Show your code if you're not sure if your code is correct.

[Feyng819]

I just tried out other codes from wide to long and it works! Thank you for your help