I have 2 lists with approximately 100 items/rows, with 5 pieces of data in
each row. Each list has a common element (account number). Many times the
account number shows on both lists, and I want to combine How do I combine
both lists to use as source data in a pivot table?