Row Spanning

library(muiDataGrid)
library(dplyr)

Row spanning allows cells to merge vertically across multiple rows when they contain identical consecutive values. This feature is useful for creating hierarchical or grouped displays.

Basic Row Spanning

Enabling Row Spanning

Enable row spanning with the rowSpanning prop

# Group characters by species
sw_grouped <- starwars |>
  select(name, species, homeworld, height) |>
  filter(!is.na(species), species %in% c("Human", "Droid")) |>
  arrange(species, homeworld) |>
  head(12) |>
  mutate(id = row_number())

DataGrid(
  rows = sw_grouped,
  rowSpanning = TRUE
)

With custom grouping display

# Add group summary
sw_with_summary <- sw_grouped |>
  group_by(species) |>
  mutate(
    species_count = n(),
    species_label = paste0(species, " (", species_count, ")")
  ) |>
  ungroup()

columns_summary <- list(
  list(
    field = "species_label",
    headerName = "Species",
    width = 150
  ),
  list(field = "name", headerName = "Name", width = 150),
  list(field = "homeworld", headerName = "Homeworld", width = 120),
  list(field = "height", headerName = "Height", width = 100)
)

DataGrid(
  rows = sw_with_summary,
  columns = columns_summary,
  rowSpanning = TRUE
)