Help with Transpose functions for multiple values and rows

[Abdemanaf]

Hi All,

I have joined recently and find this forum really interesting.

I am trying to solve an issue with 100 plus rows and I am trying to do this through a function instead of doing this manually and transpose for each row manually.

I have attached the sample here.

So Source 1 used to display the data and then Source 2 is used to transpose from columns to rows.

Can you advise how do I use functions? I tried using MATCH and then based on the MATCH function use the TRANSPOSE function to bring in the values under Fund Type 5 or can we use VLOOKUP to match the Account Name and then use TRANSPOSE function?

Appreciate your help in advance.

Thanks
Abdemanaf

Sample_output_Transpose_Help.xlsx

[AliGW]

Duplicate threads are not allowed. Continue here, please: https://www.excelforum.com/excel-for...-a-column.html