Delicious-Number

I don’t even know we’re to start to look!

I am an infant school teacher so I don’t use excel for anything complicated but I have an idea of something I want to do but I don’t know what it is called - I’m hoping if someone knows what it is that I want to do then I could find a YouTube tutorial to help me! I have had a look at some for pivot tables but that is not quite right!

I have a spreadsheet for the school with all of the children’s names in the first column. The headers for the other columns are the letters which children need to know e.g a, b, c etc. ( there are a lot more than 26 because we have all the digraph a like “ai “ and blends like “scr” which we have to test too)

For ch