Count Merged Rows

<div>0:00 This happens all the time where Learn how to filter data effectively using the query where clause. Opens in new tab we're working in Google Sheets we have some times or some data Understand the different types of data you can work with in Google Sheets. Opens in new tab in a sheet and we're going to merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab rows based on how many of these correspond right so this is three rows that they all correspond to New York City and we're going to merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab New York City in the case we might<br>0:19 be better off doing something like this but it's not always the same look and feel we may want to actually just merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab the rows and have one city here now this looks fine I can see here three But if I do this for hundreds or dozens of rows even it's going to become a little bit unwieldy to count each&nbsp;<br>0:40 and every one of these items when I really just want to know how many times did I merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab this Vancouver?<br>0:48 Well, I made a app script Explore how Google Apps Script can automate tasks in your spreadsheets. Opens in new tab that does this for you.

Uh check out app script Explore how Google Apps Script can automate tasks in your spreadsheets. Opens in new tab and you can see it here when it opens.<br>0:55 What we've done is create first we created an on open menu that this is going to be a menu right here this new menu and we're going to be able to access it.<br>1:02 But what does this row count do? We'll see what the row count simply does is take the variable rows wherever we're active so we're getting the active range Find out what the active range is and how to use it in your formulas. Opens in new tab the the selection Learn about the selection feature in Google Sheets for efficient data handling. Opens in new tab that we're in and we're getting the number Get insights on how to work with numbers in Google Sheets effectively. Opens in new tab of rows dot get number Get insights on how to work with numbers in Google Sheets effectively. Opens in new tab rows.<br>1:16 We're saying in our spreadsheet Understand the basics of spreadsheets and their functionalities. Opens in new tab that's active right now.

Create a toast menu and show us how many rows there are have the text rows and then insert that number Get insights on how to work with numbers in Google Sheets effectively. Opens in new tab here.<br>1:27 So if we are one B2 this is only one cell we click up here row count and in the bottom right it'll save rows one.<br>1:36 But now we click on NYC where Learn how to filter data effectively using the query where clause. Opens in new tab we merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab three rows we're going to click new menu row count and immediately we see rows three.<br>1:44 And this works however many times we merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab the cells Learn about cells in Google Sheets and how to manipulate them. Opens in new tab . So let's merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab those all of these into one. And go up to new menu row count and get nine rows.<br>1:56 There we go.

So very quickly we've been able to create this little tool in our sheet that counts the merged rows.<br>2:02 Our counts a number Get insights on how to work with numbers in Google Sheets effectively. Opens in new tab of rows in a merge Discover how to merge cells in Google Sheets for better data presentation. Opens in new tab cell.</div>