Transpose data

Please see this thread to which I've just responded. It is exactly similar to yours and hence the essence of the formulae are the same. The other thread was in blocks of 5 and yours are blocks of 4 so change the multipier *5 in the formula to *4

https://www.excelforum.com/excel-gen...ml#post5012571

Images/Pictures are rarely any use. In addition your picture bears no relation to your post #1

Please upload the workbook. Clearly identofy which sheets/ranges are original data and which ranges are the results and then explain in some notes how you arrive at your results.

H

The question will only become clear (at least to me) if you upload the workbook along with the other stuff I asked for in #6

Your original was clearly a much simplified example and doesn't represent the size or layout of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results. This avoids us all wasting time devising a solution for a layout that doesn't match your actual data.

Mostly, I used standard formulae, like this:

=IFERROR(INDEX(Sheet1!$D:$D,AGGREGATE(15,6,ROW(Sheet1!$D$3:$D$500)/(Sheet1!$C$3:$C$500=Sheet2!B$1),ROWS($1:1))),"")

One exception, the withdraw/completion date:

=IFERROR(INDEX(Sheet1!$D:$D,AGGREGATE(15,6,ROW(Sheet1!$D$3:$D$500)/(Sheet1!$C$3:$C$500=Sheet2!G$1),ROWS($1:1))),"")

Check the results for Vendor. Your starting data here is very messy....

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.