Bit different from the normal formula questions, but thought ppl here might have experience or bright ideas.
I've been conducting some internal interviews to give feedback/improvements for a client.
I generally use excel for notes and a lot of other text work because I can add categories, etc. and move and group things easily, so did it in xls.
Looking ahead I'd like to make a template for future use. But I'm struggling with how you have a nice first/second column with the topic which then spans multiple rows of comments, where I want columns with themes/tags to pull out later.
I feel like there must be a better method that people who do this use. Or do people have specialist tools so xls isn't used.
Bit different from the normal formula questions, but thought ppl here might have experience or bright ideas.
I've been conducting some internal interviews to give feedback/improvements for a client.
I generally use excel for notes and a lot of other text work because I can add categories, etc. and move and group things easily, so did it in xls.
Looking ahead I'd like to make a template for future use. But I'm struggling with how you have a nice first/second column with the topic which then spans multiple rows of comments, where I want columns with themes/tags to pull out later.
I feel like there must be a better method that people who do this use. Or do people have specialist tools so xls isn't used.