Transpose or cross tab help

[cireost]

Hi-

I have a rollforward schedule that shows each property's beginning balance, additions, and then ending balance.  Please see attached for example input and expected output.  

I am trying to reformat the schedule to show the property vertically with the data fields horizontally.  I believe it is a combination of transpose and cross tab tools but any help and example workflows would be greatly appreciated.

Thanks.

[ponraj]

Sample workflow as below. 

[cireost]

can you attach workflow with the input you used?  for some reason it is not reading Field_6 in my example.  thanks!