Help required in tranposing of data

Question

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.

help required.xlsx

Treyson · Accepted Answer

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 Answer

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