Transpose DataFrame of 2 columns in R, in which 1 column has all the observations

Question

my data frame has in the first column repeated labels, and in the second column all the observations. Its like a data frame made of multiple stacked data frames

Something like this:

Labels	Observations
A	x1a
B	x1b
C	x1c
A	x2a
B	x2b
C	x2c
A	x3a
B	x3b
C	x3c

I need something like this

A	B	C
x1a	x1b	x1c
x2a	x2b	x2c
x3a	x3b	x3c

Answer 1

You can do this using tidy::pivot_wider after creating a unique identifier for each Label:

library(tidyr)
library(dplyr)

df %>%
  mutate(unique = row_number(), .by = Labels) %>%
  pivot_wider(names_from = Labels, values_from = Observations) %>% select(-unique)

#   A     B     C    
#   <chr> <chr> <chr>
# 1 x1a   x1b   x1c  
# 2 x2a   x2b   x2c  
# 3 x3a   x3b   x3c