I have a data dump from a survey. Column A shows the survey #. On other sheet (sheet1) I have survey results to the questions with the survey #. I would like to compare data dump!A:A to Sheet1!A:A. If the two are equal I would like to dump the contents of Sheet1! row B in line with that survey# to Data dump B:B.
The data in sheet 1 is horizontal results from the survey. Survey #123 with all information across
The Sheet1 has formatted the data vertically so I have survey #123 listed 10 times (once for each survey question).