Crockett Member

Thanks for responding. I am going to accept this solution because I was actually able to join the data without having to collapse it!

Thank you! I actually had looked at that resource earlier but I am having trouble applying it in this situation because of the multiple columns I need to collapse for each loan. Is there another resource available that deals with more complex situations?