Transposing data from more than one variable

[Hoekstraat]

Hello everybody,

I am having problems transposing data in Excel. I have a large dataset of around 2000 mutual funds, for these funds I have cross sectional data and time series data for four different variables: Returns, concentration, active share and fund size.
Per row there is one fund with all the accompanying data in the columns right from that cell for all the time series data and other variables.

The problem here is that I cannot find a solution for how to transpose the dataset to a panel format. In the attachment you find an example of the data for three mutual funds and what the desired sollution is to the problem.
That is the best way I can describe it to you I figured.

Thanks in advance,
All pointers/tips/tricks are very welcome!

Hoekstraat

[AliGW]

Why have you started a duplicate thread when you have responses in your other thread?

Duplicate threads are NOT allowed. Continue here: https://www.excelforum.com/excel-for...g-problem.html

This thread is cosed.