Pull data from one sheet to another

[mjhopler]

this may be too much to ask, but also may be a fun challenge for someone.

I have data on sheet 1 of the attached that I need converted into the format of sheet two.

There will quite a few more loans added to this and i will need the same result on sheet 2 for each one of the additional loans.

All this is doing is pulling data straight from sheet 1; however, some loans have a different number of obligations. For example, the first has four (A through D) and the second has three (A through B) obligations.

Anyone want to take a shot?

[Marcol]

Hmmm ?

"Neither a Borrower nor a Lender Be"

Refer to Luke 6:34

A little more input might be an advantage.

Burrp!...., more beer Yum Yum.....

[mjhopler]

Sorry, going back and reading that, I realize that was completely confusing to someone not in my industry. Please see below for more details. hopefully this will help.

On the first tab, there are two loans (lets call these IDs which are in column B). On the second, there are two IDs. Both tabs contain the same data, just in different formats. However, as I go forward, the first tab will continue to have multiple IDs. For every new occurrence of an ID, I need to add a new section to the second sheet that lays out the data as the provided example does.

The second tab:
Under Notes, names these a, b, c etc...
Purpose pulls from column E of 1st tab.
Facility balance pulls from column O
Facility Limit pulls from column N
Margin pulls from column F
Maturty Date column G
Amort Type column H
Orig Am Term column I
Index column J
Uncrued column K
Pid Through column L