After doing my Leng Medal Memories interviews, I have twenty-seven transcriptions of half-hour interviews, not to mention other responses which I may wish to draw upon. The easiest way to write an article is just to sit and write about what I remember. This is a good start. But when my research is so rich in detail, I really do want to include plenty of quotes and examples in whatever I write. And I dread omitting something really important!
I have spreadsheets, oh yes indeed. Who I interviewed, when they entered the Leng Scots song competitions, what school(s) they attended, which songs they sang … and that’s just for starters.
But it’s not enough.

I toyed with the idea of creating a table with tick-boxes, so I could search on individual terms, but that wouldn’t work. If all the terms were on the table, and the table went at the top of every transcription, then every keyword would be in every transcription. How about, I mused, using the table and simply deleting concepts that WEREN’T discussed. It felt a bit like rearranging the deckchairs on the Titanic. It would take hours, and STILL I wouldn’t have arranged the data that I wanted to use into anything like useable order.
I visualised myself sticking post-it notes on a wall, like those exercises in workshops and seminars where everyone writes on their post-it notes, then sticks them in the appropriate place on a wall or whiteboard. Reader, I have no blank walls in my workspace. There’s absolutely nowhere to stick deeply significant sticky-notes, and in any case, the thought of the occupants of Testosterone Towers roaming the house with stray post-it notes clinging to their hoodies and fleeces, is both too vivid and too horrific to contemplate.
Finally, a breakthrough. I’ve sorted my key concepts into a logical order. Now I’m going through twenty-seven transcripts, taking useful quotes and putting them under each concept heading. It’ll make one large, but intelligible document that I can condense into something readably meaningful later.
(Did I hear you mention AI? Certainly not. I will succeed or fail entirely by my own efforts. None of my data is getting fed into any form of artificial intelligence – I wouldn’t dream of it.)
