If I have a data table that looks like this:
a | b | c | one | two | three
2 | 3 | 4 | 54 | 55 | 45
3 | 6 | 5 | 42 | 23 | 25
tibble::tibble(a = runif(n = 5),
b = runif(n = 5),
c = runif(n = 5),
one = runif(n = 5),
two = runif(n = 5),
three = runif(n = 5))
a and one are related, b and two are related and c and three are related (e.g. the letter is a date and the number is a measurement taken on that date).
Does anyone know how to to pivot longer so that I have a df with two columns,
letter | number
2 | 54
3 | 55
4 | 45
3 | 42
6 | 23
5 | 25
Many thanks!!