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.

[fmvizcaino · Accepted solution]

Hi @jpavlick ,

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

Best,

Fernando Vizcaino

[Emil_Kos]

Hi,

I think you can achieve this with one tool:

Output: