Ordering rows as i want

[kauser]

Hi 

i need to keep my rows as follow but after doing the calculation and mapping i am getting that current view (second table)

expecting - 

Title

FO

WS

ZA

FU

OP

Current View- 

Title	$$
OP
WS
ZA
FU
FO

Thank you 

kauser 

[usmanbashir · Accepted solution]

@kauser - Add in record ID before you transform the data, then re-sort on record ID after your calculations and mappings. 

[Raj]

@kauser 
how were these sorted 
if you have sorted them in your workflow, you can add a sort tool again after the transformation.
Else you can add a reference column in starting which can be used to sort your final data.

hope this helps.
please let us know if that does not work.