Hello All,
I am trying to find solution for my problem. Searched into this forum for Duplicates topic, no luck for my problem.
I have sheet contains the below info as Table 1 (this is just an example, I have 3000 rows and 15 columns in my sheet). I am looking for Outcome 1 and 2 as example below. Any help is really appreciated.
For outcome 1, I have tried removing the duplicates from column <Header 1> it removes everything and keep unique value as one set. I don't want that result i would like to keep the position in same place after removing the duplicates, i don't know how to do it.
For outcome 2, I have tried to looking to vlookup and hlookup option, it did not worked out.
Table 1:
[Outcome 1] in one sheet:
Remove the duplicates from <Header 1> Column and keep only one row.
[Outcome 2] in 2nd sheet: No. of test completed for patients.
Thx
Anu
I am trying to find solution for my problem. Searched into this forum for Duplicates topic, no luck for my problem.
I have sheet contains the below info as Table 1 (this is just an example, I have 3000 rows and 15 columns in my sheet). I am looking for Outcome 1 and 2 as example below. Any help is really appreciated.
For outcome 1, I have tried removing the duplicates from column <Header 1> it removes everything and keep unique value as one set. I don't want that result i would like to keep the position in same place after removing the duplicates, i don't know how to do it.
For outcome 2, I have tried to looking to vlookup and hlookup option, it did not worked out.
Table 1:
Header 1 | Header 2 (Parameters) | Header 3 (1M) | Header 4 (6M) | Header 5 (12M) | Header 6 (24M) |
Patient 1 | Wt | 50 | 55 | 75 | 100 |
Patient 1 | Length | 90 | 95 | 110 | 140 |
Patient 1 | Blood Test | +ve | +ve | -ve | -ve |
Patient 2 | Wt | 40 | 50 | 75 | 90 |
Patient 2 | Blood Test | +ve | +ve | -ve | -ve |
Patient 3 | Wt | 50 | 60 | 70 | 95 |
Patient 3 | Length | 80 | 85 | 90 | 105 |
Patient 3 | Cholesterol | 10mg/dl | 15mg/dl | 20mg/dl | 30mg/dl |
Patient 3 | Blood Test | +ve | +ve | +ve | -ve |
[Outcome 1] in one sheet:
Remove the duplicates from <Header 1> Column and keep only one row.
| Header 2 (Parameters) | Header 3 (1M) | Header 4 (6M) | Header 5 (12M) | Header 6 (24M) | |
Patient 1 | Wt | 50 | 55 | 75 | 100 | |
Length | 90 | 95 | 110 | 140 | ||
Blood Test | +ve | +ve | -ve | -ve | ||
Patient 2 | Wt | 40 | 50 | 75 | 90 | |
Blood Test | +ve | +ve | -ve | -ve | ||
Patient 3 | Wt | 50 | 60 | 70 | 95 | |
Length | 80 | 85 | 90 | 105 | ||
Cholesterol | 10mg/dl | 15mg/dl | 20mg/dl | 30mg/dl | ||
Blood Test | +ve | +ve | +ve | -ve |
[Outcome 2] in 2nd sheet: No. of test completed for patients.
Patient 1 | Patient 2 | Patient 3 |
Wt | Wt | Wt |
Length | Length | |
Blood Test | Blood Test | Blood Test |
Cholesterol |
Thx
Anu