Q:

Combine variables by adding rows

I have different columns of contentious variables and each column represents a category. I would like to combine all columns into a single column by adding the appropriate number of rows and create a new column for the category name of each row using spss or excel.
This is what my data looks like now:

This is what I want to have:

A:

This is a simple restructure, use varstocases like this:
varstocases make value  from A B C/index=category(value).

