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.
![Screenshot 2024-10-29 at 1.37.30 PM.png Screenshot 2024-10-29 at 1.37.30 PM.png](/t5/image/serverpage/image-id/69637iAE044BB895F3E6A5/image-dimensions/280x118?v=v2)
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:
![Screenshot 2024-10-29 at 1.38.35 PM.png Screenshot 2024-10-29 at 1.38.35 PM.png](/t5/image/serverpage/image-id/69638i907B0FA1091C10DB/image-dimensions/206x170?v=v2)
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!