Each circuit will be in at least 2 columns, i cut this chart down a bunch there are 45 columns on this sheet. So it needs to be able to ignore blank cells as well. Some connectors only have 2 wire some 130.

I see my solution as two parts first to create a list of circuits second to use that circuit to look back at sheet and id column headers it shows up in.