Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've got a LibreOffice calc spreadsheet with columns containing some freeform text, followed by a column with "tags" which I've entered (coded interview data). For example:

1234,"some explanation goes here","tag1, tag2, tag3"
5678,"a different one here","tag1, tag4"

What's the easiest way of creating a sheet with a row for each tag, and a column for each "row index" or whatever e.g.

tag1,1234,5678
tag2,1234
tag3,1234
tag4,5678

I know a spreadsheet isn't the ideal tool for this by the way, but I'm on the clock and don't have time to learn a complex package. I could process it in python, but I'm wary of getting sidetracked!

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.