do you mean twice as many rows or twice as many columns? if twice as
many rows then you have triplicates?
To see 4 headers above 3 columns can be a little confusing

note, it is also confusing if you use what are standard column headers
A B C & D as column A entries (without a heading entry), however, the
formula will still produce what you need, just delete the blank column
D when you are done.


I mean twice as many rows ie

List 1
Batting Score Football Score
Ben 3 4


List 2
Hockey Score Skating Score
Ace 1 2
Ben 3 7

All the entries in List 1 have 4 values. Half in List one and half in
List 2. List 2 has all the entries of List 1 and more entries that are
not in List 1. I can't arrange them seperately with the sort function
because since List 2 has twice as many entries the names still won't
align with each other. I need to get the scores next to their
respective name in one list. The scores have to stay in the right
column too.