Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SpencerMC
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automated task to present data in a graph form. luckyguy Charts and Charting in Excel 1 November 3rd 05 01:20 PM
Automated task to present data in a graph form. luckyguy Charts and Charting in Excel 1 November 2nd 05 11:51 PM
how to disable save prompt on closing excel file in automated mode [email protected] Excel Discussion (Misc queries) 3 July 6th 05 10:35 PM
Excel should let me create an automated list of the name box marisa Excel Discussion (Misc queries) 2 July 5th 05 10:22 PM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 10:57 AM


All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"