Multi row formula fill based on second column

[GoldenDesign04]

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

[PhilipMannering · Accepted solution]

Hi @GoldenDesign04 

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