How to handle data were header has less columns and replace blank columns with other column data

Asked Mar 20 '22 at 05:08

Active Mar 20 '22 at 05:08

Viewed 16 times

Hi My data has less headers compared to columns

Example dummy|4|2600

19022022|0000|abcddumm1|500|cisciscisi|abcddumm1 19022022|0000|abcddumm2|600|cidddddddi|abcddumm2 19022022|0000||700|cffffffffi|abcddumm3 19022022|0000||800|ciuuuuuuui|abcddumm4

How do I replace the blank columns with data from another columns

Desired out put

dummy|4|2600

asked Mar 20 '22 at 05:08

Govind singho

2

Provide the sample data using `dput(x)` refer https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – Nad Pat Mar 20 '22 at 05:27