Not sure if I labeled this correctly. I data coming in and joining on "connection point" a hierarchical naming convention.
Site>>Router>>Machine as a combined field.
This pulls in error codes for specific machines and their system ticket number, but the entirety of the Site should have this ticket applied to it. I've used a substring to pull the site number out of the "connection point" I figure a multi row formula to check for Site match and then add the Ticket/error code down but am unsure how to approach this:
Here is sample data:
Ticket | Error Code | Site |
Tic12345 | No Response | 0110 |
0110 | ||
0110 | ||
0158 |
Solved! Go to Solution.
I've attached an example of how you fill down.. and I've grouped it by [Site] so that it repeats for each Site. See if it suits your need.
Thanks, P