yogi_Sort by Family_ID And Separate Family_ID With An Empty Row

Google Spreadsheet   Post  #2301

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-23-2017

question by: Montblac

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/On7mIk8RPkY;context-place=forum/docs

Separating Using Empty Rows

 

How do I separate rows depending on their cell values? I need to create a family address book that lets me separate entries into family groups. I want to give entries a FAMILY_ID value and when I sort/filter using those values, I want them to be separated with an empty row. For example: 

FAMILY_ID          NAME

--------------------------------

1000                    Tim

1000                    Shane

2000                    Mark

3000                    Steve

3000                    Jim

When Sorted / Filtered:

FAMILY_ID          NAME

--------------------------------

1000                    Tim

1000                    Shane

2000                    Mark

3000                    Steve

3000                    Jim

Thanks.