Create a table out of a matrix

jpavlick

I have a data set where the first column lists states, and subsequent columns list files and amounts corresponding to each state. I want to make each amount its own "record" with associated file and state. I have attached an example.

table to matrix question.xlsx

fmvizcaino

Hi @jpavlick ,

Here it is, you can use the transpose tool to accomplish that.

Best,

Fernando Vizcaino

2021-03-10 Create a table out of a matrix.yxmd