I’m sure this is very simple but I cannot figure it out.
We’ve sent out a questionnaire to multiple individuals, each questionnaire being a single workbook.
The workbook is identical in terms of rows (i.e. the questions asked), however is unique in terms of columns, where each column represents a company name that the question relates to.
What I am now looking to do is iterate through each of the questionnaires, and append only the columns. What I am finding is that the iterate function is repeating the questions and appending the columns.
What I have done so far is expose the names of the files that I want to iterate using the “List of Files” function. I then ran an “Iterate” function calling the module where the excel questionnaires are being imported.