I am fairly new to FME and am having a tremendous issue with attempting to transpose columns into rows. I have tried the other fixes to transposing rows to columns but to no avail. Here is the sample sheet I am trying to transpose.
And under the inspector it tabulates into this
The issue is that I am wanting to combine the rows of A and C into columns and having rows B and ROM status falling underneath these columns stated above. Columns E, F, and G are not needed. I have tried using the transposer transformer as well as attribute pivoter with an aggregator but does not work. Any help would be greatly appreciated, and will answer anything I did not clarify.
