Pairing data with data from columns as criteria

[tessawanders]

Hi everyone,

I have data that looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Value[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]Ann[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Pete[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]Sylvia[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]Pete[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]Jack[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5[/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]Ann[/TD]
[/TR]
</tbody>[/TABLE]

I would want to pair data by criteria of column 1 and 3. So that it will look something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Location[/TD]
[TD]Value[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]Ann[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]Ann[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5[/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Pete[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]Pete[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]Jack[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]Sylvia[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]3[/TD]
[TD]Bob[/TD]
[/TR]
</tbody>[/TABLE]

In the next step I would like to identify the absolute and relative difference between the values of the pairs. But thats maybe a next thread. Thanks a lot for helping!!

 

[rgeorgejr]

I can't figure out what you are wanting to do. It looks like you've simply re-ordered the list. Would sorting by column 3 work for you?

 

[Gavin T]

...I would want to pair data by criteria of column 1 and 3...

You can try using a custom sort on both columns 1 & 3.