This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can Transpose all rows and columns at the same time. To ensure we have the required names and order of the columns in the final output, I suggest to create a mapping table that have all the possible column names. Attached workflow for your reference.
Thank you Lelia! This is a thing of beauty. I still have 8 questions to go with different response options and then group by the appropriate input (college, school, program and MCU), so there is still a fair bit of work to be done. Oh yeah, I still have to create the final Excel report with graphs! But this solution helps so much. Very much appreciated.