Row Match and transpose unique identifier

[Althor Blue]

Hello everyone,

First post here.

I have a problem and hopefully you guys can help me out. I have two sheets

Sheet 1 is the transpose destination after a row has been matched.

CA Nber Transpose Destination <tbody> </tbody>	Net Nber <tbody> </tbody>	Effective Date <tbody> </tbody>	Amount <tbody> </tbody>
	14035704 <tbody> </tbody>	03/10/2018 <tbody> </tbody>	$ 95.00 <tbody> </tbody>
	14045192 <tbody> </tbody>	09/25/2017 <tbody> </tbody>	$ 303.00 <tbody> </tbody>
	14045192 <tbody> </tbody>	10/31/2017 <tbody> </tbody>	$ 40.00 <tbody> </tbody>

<tbody>
</tbody>

Sheet 2 row that is matched and unique identifier for row (CA NBER) will be tranposed onto sheet 1 labeled CA NBER Transpose Destination.

CA NBR To Transpose <tbody> </tbody>	Net Nber <tbody> </tbody>	TRAN_DATE <tbody> </tbody>	AMOUNT_PAID <tbody> </tbody>
14035704A <tbody> </tbody>	14035704 <tbody> </tbody>	03/10/2018 <tbody> </tbody>	$ 95.00 <tbody> </tbody>
14045192A <tbody> </tbody>	14045192 <tbody> </tbody>	09/25/2017 <tbody> </tbody>	$ 303.00 <tbody> </tbody>
14045192B <tbody> </tbody>	14045192 <tbody> </tbody>	10/31/2017 <tbody> </tbody>	$ 40.00 <tbody> </tbody>

<tbody>
</tbody>

Hopefully this is clear and I will gladly clarify anything that is misunderstood.

Thank you!

 

[hiker95]

Althor Blue,

Welcome to the MrExcel forum.

It would help if we could see your actual raw data workbook/worksheets, and, what the results (manually formatted by you) should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com