Consider mtcars dataset (I have created a new column, called "car")
data(mtcars)
mtcars["car"] <- row.names (mtcars)
the car names contain spaces, e.g.: "Mazda RX4". I would like to split this line into two identical lines, one with "car" column contain "Mazda" and the other "RX4" with all other values being the same as in original "Mazda RX4" line