Hi Community,
I have a slightly hard cross table transformation that I need to do.
Lets say I have the below table:
| ID | FieldA.1 | FieldA.2 | FieldA.3 | FieldB.1 | FieldB.2 | FieldC.1 |
| 1 | a | b | c | r | t | y |
And I want to transpose that to:
| ID | Case | Field1 | Field2 | Field3 |
| 1 | A | a | b | c |
| 1 | B | r | t | |
| 1 | C | y | | |
Is that possible in any kind of way?
Take into account that the number of Columns in each case are not fixed so I can have case 1 with 10 fields and case B with 1.
Any help appreciated.
