Same row versus different row in Reports

Options

Hello,

Scenario:

I have two sheets, sheet A and sheet B.

On sheet A there is a column titled Survey Number, this is where the user enters the survey number. If I was to input data on Sheet B, can that information be linked to the primary column instead of creating a new row in the report? See how there's a new row (line #9) can that row be inserted above under survey number 987?


Answers