You can override the selection of which row will provide a value to the consolidated base object by clicking on the cell that is not highlighted and does not have bold text. This clicking will change the cell that is highlighted and make the text in the newly highlighted cell bold. The highlighted cell is the one that provides the data to the consolidated record.