Transposing problem

Yes, please attach a sample Excel workbook.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Would you manually add the exact results you expect to see given your example row. And please add several example rows covering all permutations of entries. I'm assuming you have at least one row per name.

In addition might you have several rows for the same name?
In the Month/Year column do you literally want a text string like January 2012? Personally iI'd use a proper date like say 1/1/2012 since that makes analysis, particularly with a pivot table much easier.

It's also not clear what you expect in the Returns and industry weights column. Please explain where these come from in the original data

Yes, it does, Sandy. It's just a very poor layout.

It's more likely that you'll need a macro to do this. But I still need to understand your data.
You've only shown one example Data Row 2. We really need to see a few more.

In addition we need to understand where the numbers in the Return column come from or how they are calculated with referenece back presumably to one of the columns in the data row.

You haven't said but I assume the Name you want in the results table is the name from column A of the data. It would also help if the results actually reflected the data. You have a single data row for February 2018 but your results able only mentions February 2012.

You need to be very specific and clear with your data and results if we are to understand precisely what you want so please include several data rows and ALL the results that flow from them. Neither do you show what you expect in the Concentration Results column.

You need to help us to help you. Rememember your data is meat and drink to you and you understand exactly what it is, and in your mind you know what you want. We are starting from scratch and have no real idea.

You are entitled to your opinion, Sandy. However:

Excel 2016 (Windows) 32 bit

	A	B	C	D	E
12	Desired solution
13	Name	Month/year	Returns	Concentration
14	Fund 1	01-Jan	0.61		=BJP2
15		Feb-12	-0.28		=BJQ2
16		01/03/2012	4.08		=BJR2
17	fund2	01-Jan
18		Feb-12
19		01/03/2012

Sheet: Sheet1

@ Hoekstraat - continue in this thread. Do not open duplicates.

As Richard has suggested, we do need more sample data. I can see where your results have come from, as you have used a direct cell reference to show us. However, what makes this difficult to solve is the column headers. It would be easier if there were two more header rows, one for the fund nuymber and another for the date.

As I have already mentioned in my earlier response to Sandy, your data layout is poor: changing it to a normalised layout (one record per data item instead of multiple columns) would make everything much easier.

is this similar to what you want to achieve?
(errors was changed to 0)

example is taken from your duplicated thread