I'm having trouble finding a way to stack multiple variables in rows with different types of data into columns.
I would like to stack each series of 1, 2, 3 into 3columns but I'm not finding what I'm looking for in any help documentation
Turn:
Into:
You should be able to do that by just checking Multiple Series Stack, and Number of Series = 3. You'll just have to delete the resulting labels columns afterwards. I tested it with 6 columns where the 2nd and 4th were both nominal and the resulting table had 3 label and 3 data columns. The second data column had a nominal data type as would be expected.