Transforming of data

[hiteshnpwc]

Hello Everyone,

I am finding difficulties to build a workflow Using Balance sheets and looking for an Output. I have attached the data file of the input data file and the expected output. And attached my existing workflow

[Miles_Waller]

This is what I came up with.

I think the main difference is that I started my data import a couple rows higher so I could use multi row formulas to bring in the the right categories and Adj. No. for each record. Then I used transpose and sort to put everything else into one column where I could use another multi row formula to fill in the blanks. Then I cross tabbed it back into a table format where I could sort it by record ID, use a regex tool to get account description, then do some find replaces to come up with other fields you needed in your output. After that it was just a summarize tool to get totals grouped by Adj No (Or SUM #) and account category, then cross tab again to put it in tabular format, union with the full list of fields you want, then output.