How to manipulate certain columns into rows

Asked Jul 30 '20 at 13:56

Active Jul 30 '20 at 13:56

Viewed 25 times

I have a dataset that looks like the following:

Id | Name | year | Offer1 | Offer2 | Offer3
1    Joe    2019   Army    Navy     UGA
2    Sally  2019   UA      UVA      UF

Is there any code in R or VBA that would transpose the dataset to look like this:

Id | Name | year | Offer
1    Joe    2019   Army
1    Joe    2019   Navy
1    Joe    2019   UGA
2    Sally  2019   UA
2    Sally  2019  UVA
2    Sally  2019   UF

asked Jul 30 '20 at 13:56

g_math_324

1

`tidyr::pivot_longer(df, cols = starts_with('Offer'))` – Ronak Shah Jul 30 '20 at 14:08
`data.table::melt(data.table::setDT(df),measure.vars = patterns("Offer"),value.name = "Offer")` – denis Jul 30 '20 at 14:56

How to manipulate certain columns into rows

0 Answers0