Hi folks, i'm trying to get to a stage where i can do a vlook up and the simplest way i can think of is to organise the column information from column to row, so i have only one entry for each person, although i need the row value also to be sorted lowest value on the left. is this possible?
<tbody>
</tbody>
thanks in advance!
name | value | name | value | value | value | value | ||||
person1 | 2 | person1 | 1 | 2 | 4 | |||||
peson2 | 3 | goes to -> | person2 | 3 | 11 | |||||
person1 | 1 | peson4 | 4 | 5 | ||||||
person1 | 4 | |||||||||
person2 | 11 | |||||||||
peson4 | 4 | |||||||||
peson4 | 5 | |||||||||
<tbody>
</tbody>
thanks in advance!