Hi,

This is quite tricky for me to explain but I'll give it a go...

I have some data with a Unique Identifying number next to it. For Example:

UID Valid Needed
1 Yes No
3 No Yes
4 Yes No
5 Yes Yes
7 Yes Yes
9 No Yes

What I'm needing to do is, Paste this data into another spreadsheet next to some data where the UID matches the row.

Where:
UID 1 goes into row1
UID 3 goes into row3
UID 4 goes into row4
etc.

Obviously It would be easy to just do a normal copy and paste but I have some UIDs missing and it would take forever to sort this out manually as the spreadsheet has about 80K rows.

Is there an easier way to do this?