My source data includes File #, Name and Title. There are up to 10 Name/Titles associated with each File#, and the Names are often repeated with a different Title in each File. I need to show all the data by File #. Lookup only picks up one data set per file. Can you help? Thank you!
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>
Source Data (6500+ rows) | |||||||
File # | Name | Title | |||||
A101 | John Smith | President | |||||
D202 | Sam Brown | VP 1 | |||||
B101 | Bill Green | VP 2 | |||||
C202 | Jeff Thomas | VP 3 | |||||
A101 | Jeff Thomas | Tech 1 | |||||
D202 | John Smith | Tech 2 | |||||
B101 | Bill Green | Tech 2 | |||||
A101 | Pete Peters | Tech 1 | |||||
D202 | Gene Johnson | Tech 3 | |||||
Result (over 1200 File #s to match for data) | |||||||
File # | Name | Title | Name | Title | Name | Title | |
A101 | |||||||
B101 | |||||||
C202 | |||||||
D202 | |||||||
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>