How to get the rows to be aligned into one row

[jessy_chow]

Here are my results from 2 summarize. 

I need to take SUM_610200 Office Supplies / Sum_FTE Total. (37982/1224.84) However since they are are on different rows, I am unable to use the formula function to do the calculation. How can I the results to look like the following. 

Sum_FTE Total	Sum_610200 Office Supplies
1224.84	37982

[davidskaife · Accepted solution]

Hi @jessy_chow 

Assuming your two records are coming in from two separate streams just use the Append Fields tool

[jrlindem]

Can you provide more of the workflow upstream to this?  Seeing the SUM_ prefixes i'm guessing you've got a summarize tool in your workflow, but exploring the Transform tools to modify your workflow to include a Cross Tab or Transpose will likely help.  But if you can provide more context, I'm sure someone can build you out a proof-of-concept.

[JosephSerpis]

Hi @jessy_chow you may need to apply a filters before your summarise to remove any Null records from both columns. Using the filter tool would achieve this. I would add two filters filter out the Null records as a proof on concept before you summarise to see if this resolve the issue and gets all the data aligned.

[jessy_chow]

Thanks! This worked!