So you may be wanting to format your sheets like this in a particular case. We have diseases on the left and then some notes on the B column. So what happens is you can sort this if and only if you put the same word in all of these A columns. So if we did this, we could select these, this range and we could go up to data and we could sort range and column. A A to Z there. But if we don't have these particular things filled out, if we just want one word here, then now we have these sort of blocks that to humans and to us it's very readable. We can see flu and then see these are blank. And we can even go view show, no grid lines.

And it really helps actually that there's not all of these words here. Another way to format without having to do anything else is to just put these inside of one cell. And this is actually what I prefer. I do this with command. Enter just a new line and then I can add some more notes here. Right. And this disease over here. Yes. Now is is alphabetical lies a bowl. You can sort it. That's however, only if you want to avoid having to do some app script , but I actually already wrote the app script . Go up to extensions app script and we can go here and we can see the app script . And if you're watching this on Better sheets.co down below, you can get this exact script.

If you're watching this somewhere else, there should be a link in the description to get this. And what it is is just sorting the. Groups. These are groups and it's saying basically go to the next. Let's delete that one. Let's go down here, see all of this. This is all one group . Treat it as a group and then sort it. And that's really all this is doing. You can set a few variables here, like where you want to start the row. If you have more headers , you can have a start column where you want to actually alphabetize it by, and then how many columns you have. You can change that as well. Here in lines three, four, and five. And there you go. You can copy and paste this app script and I'll show you how it works is we're on sheet one. It's actually the active sheet and we can actually change this a little bit.

If you wanna change this, get active spreadsheet , get sheet by name, and just put sheet one there. Now, every time I run this, I'm just gonna go up, select this here, click run. It's already sorted. Everything there. There's my flu there all in one block or one line instead of a whole block or whole group . This is pretty cool because again, you can sort your notes this way, but again, I do like to sort of do the very manual way sort it just put all of my notes in one cell. But if you do want to do something like. This and have multiple rows. There you go. You have an app script to do that for you sort column A in groups. Get it today and no fuss.

You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.