insert group header -- above a group of rows -- based on consistent value within the group

Hi. I have several groups of data in the same sheet. Each group has two blank rows above the first row of data. Each group has column "B" in common (e.g., "Phone" in the example attached). I'd like to add a title/label of "Phone" to the first column in the row immediately preceding the first row of data for that group. I've searched and can't find a simple solution. Thank you for your help, as always.

try the following macro.

Please Login or Register  to view this content.