Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automated summaries/conversion
I have a spreadsheet that is generated by an online suvery. The results are
returned with one row per survey, questions by columns. For multichoice/single answer questions (Strongly Agree, Agree, Disagree, Strongly Disagree etc) the sheet puts each of the options as a column heading and then inserts a "1" in the corresponding column for each survey. Therefore each survey will only have one "1" under these headings. Is there a way of converting this into a single column where Agree, Disagree etc are shown in the same column for each line of the sheet. In other words, you can read across a row, instead of looking for a "1" and working out which column it relates to, there is the word Agree (or whatever option they chose) in a column. Not sure where to begin with this. Not a Excel expert! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated task to present data in a graph form. | Charts and Charting in Excel | |||
Automated task to present data in a graph form. | Charts and Charting in Excel | |||
how to disable save prompt on closing excel file in automated mode | Excel Discussion (Misc queries) | |||
Excel should let me create an automated list of the name box | Excel Discussion (Misc queries) | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions |