Transpose a long-format sheet to wide-format
Usage
transpose_sheet_to_wide(file_path, sheet_name, id_col, key_col)
Arguments
- file_path
The path to the Excel file.
- sheet_name
The name of the sheet to import.
- id_col
The column name that contains unique identifiers.
- key_col
The column name that will become the new columns in the wide format.
Value
A tibble in wide format.
