How to stack columns?

[#1]

I have a data set with 22 subjects' active and placebo sides been tested for 4 times at 0w, 4w, 8w and 12w. Now I want to stack those columns of data (Active 0W, 4W, 8W,12W and Placebo 0W, 4W, 8W,12W)into one result column and also create two columns named Active/Placebo and Time to accurately describe each subject's result. I have attached the data table that I have and also the data table that I want to make. How do I do it?

[#2]

Use

     Tables=>Stack

to stack the columns

Then create 2 new columns using these 2 formula.  Both columns should be defined as character columns.

Foe the Acrive/Placebo column

word(1, :label, " ");

For the time column

word(2, :label, " ");

[#3 · Accepted solution]

Besides using formulas, you can also split the Label column with following:

1. Select Label Column
2. Go to Text to columns in Cols / Utilities / Text to Columns...
3. Use space as delimiter
4. Delete Label column and rename the columns

[#4]

Thank you very much for helping out!!!!! It worked!!