Make Column tools help

cireost

Hi - I have built a workflow using the Make Column tool to essentially transpose each column and the respective data within that column to fit nicely within a table.   However, I have one tenant that has 1 extra row of data in the Building Share % column called (varies), which is throwing off the workflow.  Might be easier to see input file with comment.  Instead of (varies), the result should have shown 0.36%.   Please advise on how I can address this.

Thanks!

Report transpose cross tab help3.xlsx

Report Transpose Crosstab help.yxmd

CarlDi

hi @cireost,

If you modify your 2nd filter tool to exclude "varies" (!IsNull([F2]) and [F2]!='(varies)'), then the 0.36% entry will be where you expected. Question is, does it make sense to filter it out? The other streams didn't have it.