kn_forum_transpose_excel_questions

Transpose with multiple sheets without duplicating columns

----------
Hi there -

I am trying to combine several versions of the same Excel form so that the column structure is permanent with the information added underneath (my data input). Questions in the Excel forms are listed in one column, with responses in the next column. My desired data output is an Excel form is a table where each question is listed as a column header with the corresponding responses below from every form.

External resources

• forum entry