I have an Excel sheet that I am looking to combine two columns from one sheet into a new sheet. I am including the Excel file.
The columns are the B and R from the Title_Frame_Register sheet. I am trying to output to a new sheet and it what I am trying to do is list the output with same name in one row to avoid duplication but have there ID numbers listed.
For example it would be C202-C204 HORIZONTAL GEOMETRY PLAN listed one just one line on the new sheet.
Any assistance offered would be appreciated.