R manipulating data frame pivot

R manipulating data frame pivot

pI have some data in a csv file as below. /p precodeFood Calories
Cholesterol Total_Fat Sodium Frozen_Broccoli 73.8 0 0.8 68.2 Carrots,Raw
74.8 23.7 0 0.1 /code/pre pcode to create that data is:/p precode
row3=c('Cholesterol', '0', '23.7') row4=c('Total_Fat', '0.8', '0')
row5=c('Sodium', '68.2', '0.1') row2=c('Calories', '73.8', '74.8')
row1=c('Food', 'Frozen Broccoli', 'Carrots,Raw') original lt;-
data.frame(row1, row2, row3, row4, row5) original /code/pre pI would like
to transpose part of data so that it looks like below. /p
precodeFrozen_Broccoli Calories X73.8 Frozen_Broccoli Cholesterol 0.0
Frozen_Broccoli Total_Fat 0.8 Frozen_Broccoli Sodium 68.2 Carrots,Raw
Calories 74.8 Carrots,Raw Cholesterol 23.7 Carrots,Raw Total_Fat 0.0
Carrots,Raw Sodium 0.1 /code/pre pI can create the data using Excel and
vba. But is their a way to do the same in R?/p