I want to have a new spreadsheet that pulls the position
number, percentage allocated, and the accounts. I know how to easily pull
this information in when there is only one line. The problem is that for one
position number there may be multiple percentages along with different
accounts. (Note: The end goal is to run a pivot table on the information so
I would prefer to have multiple rows vs multiple columns.)

Employee Key Spreadshee
This has one line per employee. One employee holds only one position
number, but the position number could be allocated to more than one
department).

Percentage Key Spreadsheet (
Pos # % Alloc Dept Exp
1A 100 200 50000
2A 95 205 50001
2A 5 204 50001


New Spreadsheet (pulling and being populated with the information from
Percentage Key spreadsheet and employee key spreadsheet)

Pos# Emp % Alloc Dept Exp Salary
1A Jane D 100 200 50000 100.00
2A John D 95 205 50001 95.00
2A John D 5 204 50001 5.00


Thanks in Advance