I have 598 long-form, semi-structured ethnographic interviews as a base data set, and I am looking to extract the paired questions and responses between interviewer and interviewee and have them added to rows in a spreadsheet. A sample snippet from one interview is appended below.
Short of manually cutting and pasting each question and response pair into a spreadsheet, I’m looking for a solution that parses the questions and responses. I suspect this may be some sort of regex function or some hybrid set of string or document manipulation tasks.
I do already have a set of extracted Q&A pairs from about 50 interviews, and so we have good coverage on the range and variation of questions (~16 questions+ responses per interview).