converting a dataset from a long to wide format.

[Elhewins]

I am very new to R and not sure on the correct code to use to complete this action.

I need to convert this dataset from long to wide format. The columns (Responseld, Duration, interest and def) were measured twice in the wave column (1 and 2). so i want to create two columns for each Responseld, Duration, interest and def that represent the scores taken in wave 1 and wave 2.
This is the code i was trying to use.

pivot_wider(data, names_from = "name",
values_from = "value")

This is an example of my data.
structure(list(id = c("R_00A0gwBx63DxWmt", "R_00A0gwBx63DxWmt",
"R_0ciHrETdEv7DlOp", "R_0ciHrETdEv7DlOp", "R_0DRBQNJIiHypFWV",
"R_0DRBQNJIiHypFWV"), wave = c(1, 2, 1, 2, 1, 2), ResponseId = c("R_00A0gwBx63DxWmt",
"R_3HYwAtNSInhNWIj", "R_0ciHrETdEv7DlOp", "R_2uxsAbFPu3Ewip7",
"R_0DRBQNJIiHypFWV", "R_3j6yWC4gn1fOeBd"), Duration = c(223,
159, 289, 183, 129, 102), interest = c(4, 3, 4, 3, 7, 7), def = c(7,
4, 4, 4, 4, 4)), row.names = c(NA, -6L), class = c("tbl_df",
"tbl", "data.frame"))

The top image is the untouched dataset and the image below it is what i am trying to change my data into

[StatSteph]

Thanks for your first post! Can you post a reproducible example? Show us some of your data and manually make an example of what you want the result to look like after making wide.

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[Elhewins]

Thanks Steph, i included an image of what the dataset looks like now and what i want to make it look like after making it wide

[StatSteph]

Screenshots are not reproducible examples. Please look at the linked guides. They help people help you.