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.
I've used excel for something similar before. I always have the topic field entered on every row, because I might want to filter by topic later.
If you want it to print nice with row spanning you could always conditional format it to white text if the value is the same as the one above.
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.