Hello!
I process a lot of data sets with a unique format. They contain a matrix of data with a corresponding "map" of their labels. I've made a simplified version here as an example. The sample labels are in the first rows, followed by the data itself. For example, Sample 1 was measured 3 times and results are 20, 30, 40.
I want to transform this data set so that the label is in column 1 and the corresponding data is in Column 2, like so:
I haven't figure out how to do this with any of the "Table" functions. I was playing around with stack to get them all into one column, but I can't grab the bottom rows and bring them over to a new column. I realize I can just copy-paste at this point, but I am looking to build a workflow.
Thanks!
Accepted Solutions
Transpose your data and delete the Label column
Then use
Tables=>Stack
and use a Multiple series stack to get what you want
Transpose your data and delete the Label column
Then use
Tables=>Stack
and use a Multiple series stack to get what you want