Help required in tranposing of data

[shankar12]

Hi, 

i am trying to consolidate multiple sheets of balance sheets, concern here is transpose of certain fields, attached sheet contains the data.

1 sheet available data format and second sheet contains required format

Thanks in Advance.

[Treyson · Accepted solution]

There are a bunch of ways to do this. I use the multirow because I like it. However if some of the assumptions in that formula don't remain true, it will break. But here is my shot at it.

[ponraj · Accepted solution]

You can achieve the results for your case using Multirow formula tool and transpose tool. 

[shankar12]

Thanks