Hi Folks - long time listener, first time caller.
Problem Summary: I need to dynamically add rows below an cell and populate those cells with unique values found in the anchor row.
Contextual Detail: Data set is below but each unique entity has a document associated with it and additional documents also associated with it. Each entity, document, and related document all of unique IDs. I need to create a view which has entity ID, entity name, and unique document IDs on each row/record.
Specs: I am using MS Excel 2013.
Raw Data Set:
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Entity ID[/TD]
[TD]Entity Name[/TD]
[TD]Document Serial Number[/TD]
[TD]Related Document Serial Number[/TD]
[TD]Total Number of Documents[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]9475,6624,868,782,720[/TD]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Braco[/TD]
[TD]5539[/TD]
[TD]4682,6624373570[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4952[/TD]
[TD]Charlie[/TD]
[TD]5548,4682[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
End Goal:
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Entity ID[/TD]
[TD]Entity Name[/TD]
[TD]Document Serial Number[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]9475[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]6624[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]868[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]782[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]720[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Bravo[/TD]
[TD]5539[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Bravo[/TD]
[TD]4682[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Bravo[/TD]
[TD]6624373570[/TD]
[/TR]
[TR]
[TD]4952[/TD]
[TD]Charlie[/TD]
[TD]5548[/TD]
[/TR]
[TR]
[TD]4952[/TD]
[TD]Charlie[/TD]
[TD]4682[/TD]
[/TR]
</tbody>[/TABLE]
Highly appreciate any and all comments. Thanks!
Problem Summary: I need to dynamically add rows below an cell and populate those cells with unique values found in the anchor row.
Contextual Detail: Data set is below but each unique entity has a document associated with it and additional documents also associated with it. Each entity, document, and related document all of unique IDs. I need to create a view which has entity ID, entity name, and unique document IDs on each row/record.
Specs: I am using MS Excel 2013.
Raw Data Set:
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Entity ID[/TD]
[TD]Entity Name[/TD]
[TD]Document Serial Number[/TD]
[TD]Related Document Serial Number[/TD]
[TD]Total Number of Documents[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]9475,6624,868,782,720[/TD]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Braco[/TD]
[TD]5539[/TD]
[TD]4682,6624373570[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4952[/TD]
[TD]Charlie[/TD]
[TD]5548,4682[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
End Goal:
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Entity ID[/TD]
[TD]Entity Name[/TD]
[TD]Document Serial Number[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]9475[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]6624[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]868[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]782[/TD]
[/TR]
[TR]
[TD]5456[/TD]
[TD]Alpha[/TD]
[TD]720[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Bravo[/TD]
[TD]5539[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Bravo[/TD]
[TD]4682[/TD]
[/TR]
[TR]
[TD]7656[/TD]
[TD]Bravo[/TD]
[TD]6624373570[/TD]
[/TR]
[TR]
[TD]4952[/TD]
[TD]Charlie[/TD]
[TD]5548[/TD]
[/TR]
[TR]
[TD]4952[/TD]
[TD]Charlie[/TD]
[TD]4682[/TD]
[/TR]
</tbody>[/TABLE]
Highly appreciate any and all comments. Thanks!