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.