'How to handle data were header has less columns and replace blank columns with other column data
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
19022022|0000|abcddumm1|500|cisciscisi|abcddumm1 19022022|0000|abcddumm2|600|cidddddddi|abcddumm2 19022022|0000|cffffffffi|700|cffffffffi|abcddumm3 19022022|0000|ciuuuuuuui|800|ciuuuuuuui|abcddumm4
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|