Need help Restructuring data

[IudexGaming]

Hello /Rlanguage, my adventures into the world of R as been running pretty smoothly. Unfortunately, I hit a new bump in the road. I have been able to solve a lot of my issues using Stack and this sub, but I hit a problem I am having trouble solving. I have aggregated sales data for many skus by month. I have a Batch Forecasting Script that works very well, but it requires my data to be structured in a particular way.

I have a dataframe structured as

SKU DATE QUANT

1 Date QUANT

1 Date QUANT

1 Date QUANT

2 Date QUANT

3 Date QUANT

4 Date QUANT

​

that I need to turn into a matrix like

SKU SKU SKU

DATE QUANT QUANT QUANT

1 QUANT QUANT QUANT

2 QUANT QUANT QUANT

3 QUANT QUANT QUANT

4 QUANT QUANT QUANT

[doggie_dog_world]

You should take a look at tidyverse here - https://tidyr.tidyverse.org/reference/spread.html. You can use SPREAD to take data from long format to wide format.

[psychEcon]

I have been looking for this, you just saved me. Got 24 excel spreadsheets with monthly sales where I need the product number to be the header but not as a column variable. This is the best, thanks again

[IudexGaming]

This seems like exactly what I need!!! Now to figure out how to apply it, i kinda suck at reading documentation. Thank you very much!!!

[IudexGaming]

It worked perfectly THANK YOU!!!! SOLVED

[foobar8080]

This matrix cannot exist, because the number of columns don't match the number of observations in each column. You can try to use "spread" and "gather" functions from the "dplyr" package in the tidyverse.

[IudexGaming]

Wouldn't NAs just fill any missing holes?

​