Database Folk - Sanity Check
I wonder if anyone familiar with databases could give me a sanity check?
I have a excel document with around 100 columns the data is from a survey tool, I need to get multiple answer columns into one, I also need to make the adjacent column equal the question posed which is the column label in the source xsls.
I have a manual way to do this but is a pain as there are 20 + columns and there not contiguous.
As we are a mac household I have been considering using mysql but before committing the time to learn this I wanted to check if its posable?
The output I'm after would look like:
Column1 some demographic data,
Column2 some demographic data,
Column3 Answer,
Column4 Question (This is the column name from source of the previous column),
Column5 Question # (I'm assuming a second table and look up Column4 and return its question #),
Ideally I could have a single query that would do this for multiple answer columns, e.g. columns 4,6,9,12,23,24 all are free form text responses, hence the adjacent report column is the question so it can be evaluated by a human.
I'd then export this back to excel for someone else to analyse and mark as relevant or not.
db's aren't my thing (obviously) so apologies if I've asked a clunky question or used the wrong terminology.
TIA for any and all replies.