I am trying to transpose the output of an Excel writer.

 

 

I have only 1 row of values to transpose perhaps there is an easier way? e.g

 

field1, field2, field3

 

vala, valb, valc

 

 

should become

 

 

field1, vala

 

field2, valb

 

field3, valc

 

 

 

I used the example Transpose2015.fmwt on http://fmepedia.safe.com/articles/How_To/Advanced-manipulation-of-Excel-tables-using-AttributeExploder.

 

 

However my output attributes are not ordered.  It appears the incoming order of the attributes is lost when the AttributeExploder is applied?

 

 

Is there an easy to resolve this or an easier method to achieve the same?  I had a brief look at the ListPivotDemo but am waiting for the database outage to be resolved before I can test.

 

 

Thanks,

 

 

Annette