Helpless_Tim
New Member
- Joined
- May 16, 2019
- Messages
- 5
Hi,
I'm looking to sort two sets of data so that matching pairs appear in the same rows and gaps appear where there isn't a match. The end result would look something like this:
<tbody>
</tbody>
The columns either side of these (A and D, assuming that the above are B and C) need to then be compared, but the references contained in columns B and C are what needs to be matched up.
I use this method regularly and currently sort the data manually - a way to do it in a few button clicks would save me loads of time!
Cheers,
H_T
I'm looking to sort two sets of data so that matching pairs appear in the same rows and gaps appear where there isn't a match. The end result would look something like this:
1 | 1 |
2 | |
3 | 3 |
4 | |
5 |
<tbody>
</tbody>
The columns either side of these (A and D, assuming that the above are B and C) need to then be compared, but the references contained in columns B and C are what needs to be matched up.
I use this method regularly and currently sort the data manually - a way to do it in a few button clicks would save me loads of time!
Cheers,
H_T