I am creating duplicate views and I am pulling the names and room numbers from an excel spreadsheet. I am trying use the data from two columns of the spreadsheet in the name field. I have tried Join and concat but they only rename the 1st and the last views with all the data form all rows of the column 8 and and 9. I am able to use either one of the columns to rename the dependent views.
Am I using the Join and Concat as intended?
Thank you for any advise.