Hi, I have data that looks like this. The data is annoyingly a horizontal output where the top row is a sort of ID. I want to transpose this data, so the ID are on the left column and all the relevant data lines up.
| XYZ | | 1201 | 1213 | 1276 | 1310 | 1311 | 1399 | 1455 |
| | | | | | | | | |
| ABC | 1 | | 5 | | | | | |
| UIO | f | | k | | | | | |
| TYU | P | | 9p | | | | | |
| GHJ | 42 | | 113051 | | | | | |
| VBM | 76 | | -51 | | | | | |
Then, I have another file like this below. I have to make my data at the top eventually match the below so that it can be uploaded. Note Field1 is the ID.
| Log | VALIDATE | Field1 | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 | Field8 | Field9 | Field10 | Field11 | Field12 | Field13 | Field14 | Field15 | Field16 | Field17 |
| Required | | 1201 | 1 | 2024 | 12 | Tax | 1 | | | f | | | 76 | | 42 | | | P |
| | | 1213 | 5 | 2024 | 12 | Tax | 5 | | | k | | | -51 | | 113051 | | | 9p |
| | | | | | | | | | | | | | | | | | | |
I have a file that maps each code on the first file to the field like this. The plan is to use this a match lookup value so that I can then populate the template (middle table on this post)
| XYZ | Field1 |
| | |
| ABC | Field6 |
| UIO | Field9 |
| TYU | Field17 |
| GHJ | Field14 |
| VBM | Field12 |
I had setup pivot tables on excel but it's crashing maybe due to the volume of data. Additionally, the values on the fields on my source data are very long and they get truncated on my pivot. Hoping Alteryx can jump in to have something we can rely on for these batch uploads.
