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:
<tbody>
</tbody>
End Goal:
<tbody>
</tbody>
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:
Entity ID | Entity Name | Document Serial Number | Related Document Serial Number | Total Number of Documents |
5456 | Alpha | 9475,6624,868,782,720 | 5 | |
7656 | Braco | 5539 | 4682,6624373570 | 3 |
4952 | Charlie | 5548,4682 | 2 |
<tbody>
</tbody>
End Goal:
Entity ID | Entity Name | Document Serial Number |
5456 | Alpha | 9475 |
5456 | Alpha | 6624 |
5456 | Alpha | 868 |
5456 | Alpha | 782 |
5456 | Alpha | 720 |
7656 | Bravo | 5539 |
7656 | Bravo | 4682 |
7656 | Bravo | 6624373570 |
4952 | Charlie | 5548 |
4952 | Charlie | 4682 |
<tbody>
</tbody>
Highly appreciate any and all comments. Thanks!