Craig Peter DG
New Member
- Joined
- Sep 10, 2016
- Messages
- 33
- Office Version
- 2013
This is rather difficult to explain the problem folks, hope someone can understand my problem.
I have a table of Source Data with Number ID's running down Column A, some of these numbers (alot of them) are duplicates because that is how the source data I am pulling from was entered. One patient may have reported MULTIPLE symptoms but there was only 5 Symptom columns. Obviously the Source Data dbase only allowed for 5 columns across the page next to each ID number. So, source data contains DUPLICATE ID's with Unique Symptoms. NB: The symptoms for each patient ID are not duplicated, only the patient ID is duplicated, down column A. as in this picture (I have identified the duplicates with conditional formatting color red.
Problem is, my data table which is where I am consolidating all the source data, currently only has the patient ID listed once, yet, the source data may contain MULTIPLE entries against that patient ID number. (this shows my main data table with only unique patient ID's currently entered.)
I need a workaround that will allow me to bring the duplicate patient ID's with all their symptoms, from the source data into my main data worksheet. I do not want MORE THAN 5 columns of symptoms in my main data worksheet as it will be too wide and I am going to PIVOT table the final data.
Is this a macro solution or a function solution? I am not sure how to extract every duplicated patient ID from the source data into the main data, or a better word would be to MERGE i suppose.
Thanks everyone, sorry for the long problem.
Craig
I have a table of Source Data with Number ID's running down Column A, some of these numbers (alot of them) are duplicates because that is how the source data I am pulling from was entered. One patient may have reported MULTIPLE symptoms but there was only 5 Symptom columns. Obviously the Source Data dbase only allowed for 5 columns across the page next to each ID number. So, source data contains DUPLICATE ID's with Unique Symptoms. NB: The symptoms for each patient ID are not duplicated, only the patient ID is duplicated, down column A. as in this picture (I have identified the duplicates with conditional formatting color red.
Problem is, my data table which is where I am consolidating all the source data, currently only has the patient ID listed once, yet, the source data may contain MULTIPLE entries against that patient ID number. (this shows my main data table with only unique patient ID's currently entered.)
I need a workaround that will allow me to bring the duplicate patient ID's with all their symptoms, from the source data into my main data worksheet. I do not want MORE THAN 5 columns of symptoms in my main data worksheet as it will be too wide and I am going to PIVOT table the final data.
Is this a macro solution or a function solution? I am not sure how to extract every duplicated patient ID from the source data into the main data, or a better word would be to MERGE i suppose.
Thanks everyone, sorry for the long problem.
Craig