Hello,
See a test data file attached. Trying to figure out a workflow that will accomplish the following:
Thanks in advance!
Solved! Go to Solution.
1) use the Multi-row tool. Formula would be something like
IF IsEmpty([FieldName] THEN [FieldName:Row-1] ELSE [FieldName] ENDIF
2) Try the Transpose tool. Should do exactly what you're asking for.
Chris
Thank you - this is very helpful.
One follow up question - what adjustment would be needed to the workflow if I wanted what is currently in the output "Field" column to be separate column headers? So additional columns for ConsCalc, Elim, Journals, ConsolAdj, GLLoad, etc.?
@bradaba You could use a crosstab tool to set the 'field' column to be the header values.