Add header rows within a column for values that repeat.

Often helpful when wanting to create sub-groupings within a column in a final output.

in_row_headers(.data, col)

Arguments

.data	A tbl.
col	Column to add subheaders to.

Examples

df <- tibble::tribble(
  ~Label, ~value,
  "A", 1.2,
  "A", 1.3,
  "B", 5.0,
  "C", 4.3,
  "C", 4.1,
  "C", 5.2,
  "D", 6
)
df %>% in_row_headers(Label)
#> # A tibble: 9 x 2
#>   Label value
#>   <chr> <dbl>
#> 1 A      NA  
#> 2 A       1.2
#> 3 A       1.3
#> 4 B       5  
#> 5 C      NA  
#> 6 C       4.3
#> 7 C       4.1
#> 8 C       5.2
#> 9 D       6