mple_elephantes
New Member
- Joined
- Aug 10, 2014
- Messages
- 4
Dear all,
I have six different spreadsheet, each one having a total of 8 (A-H) columns (and various rows). The data have to with patents, and what I need is the following: some patents appear more that one times but each row has different values. What I need is to merge the duplicates but keep the unique values. I have also attached an example. I have come to realise that I need some sort of a code, but I really dont know how to do it. CAn someone please, please help me!!
<tbody>
</tbody>
I have six different spreadsheet, each one having a total of 8 (A-H) columns (and various rows). The data have to with patents, and what I need is the following: some patents appear more that one times but each row has different values. What I need is to merge the duplicates but keep the unique values. I have also attached an example. I have come to realise that I need some sort of a code, but I really dont know how to do it. CAn someone please, please help me!!
Turn this: | |||||||
appln_id | appln_filing_year | appln_auth | ipc_class_symbol | person_ctry_code | sector | applt_seq_nr | invt_seq_nr |
21487773 | 2005 | GB | H01L 31/042 | JP | COMPANY | 1 | 0 |
21487773 | 2005 | GB | H01L 31/042 | GB | INDIVIDUAL | 0 | 1 |
21487773 | 2005 | GB | H01L 31/042 | GB | UNIVERSITY | 0 | 2 |
Into this: | |||||||
appln_id | appln_filing_year | appln_auth | ipc_class_symbol | person_ctry_code | sector | applt_seq_nr | invt_seq_nr |
21487773 | 2005 | GB | H01L 31/042 | GB/JP | COMPANY/INDIVIDUAL/UNIVERSITY | 1 | 1 |
<tbody>
</tbody>