topic Re: How to stack columns? in Discussions

How to stack columns?

AlphaPony501 — Sat, 10 Jun 2023 23:47:36 GMT

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?

Re: How to stack columns?

txnelson — Sun, 24 Apr 2022 01:42:34 GMT

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, " ");

Re: How to stack columns?

jthi — Sun, 24 Apr 2022 06:00:48 GMT

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

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

Re: How to stack columns?

AlphaPony501 — Mon, 25 Apr 2022 01:04:21 GMT

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