Help with making complex survey responses useful

Phontonx

New Member
Joined
Nov 2, 2018
Messages
1
We have posted a survey and have received many answers. Unfortunately, there is no relationship in our CRM and the questions have all become jumbled. I am wondering if there is a way to process the data in Excel to make the data useful.

For instance:
  1. Identify shared time stamp (survey is submitted and all Q&A get the same time stamp
  2. identify question (there are multiple instances of the same question - one for each response, only one serial number per time stamp, though, if that helps)
  3. populate answers across the rows, so data can be sorted and filtered

I can add numbers to questions if that would help, but the current data does not have them. If it is needed, I can manually add them.

Is this too much for Excel to do? Or am I even going about it wrong? I am open to any suggestions, but we will be getting upwards of 100 surveys sent in and I am overwhelmed with this small group already!

A simple screenshot will not suffice, I will be happy to share an anonymized copy of the spreadsheet I am trying to work with. I know attachments are not allowed, and did not see anything about links, so have not provided one yet.

Looking forward to any help! Thank you!
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Logit

Well-known Member
Joined
Aug 31, 2016
Messages
3,237
.
You can use DROPBOX, or Google Cloud, or Amazon Cloud, etc. to post a download.
 

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
Phontonx,

Welcome to the MrExcel forum.

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,142
Messages
5,466,923
Members
406,510
Latest member
wizekor

This Week's Hot Topics

Top