Forum Discussion

theInsider's avatar
theInsider
Copper Contributor
Feb 10, 2022
Solved

Shifting of excel rows

So I want to shift all the rows /columns to the left .If you see that if i filter education columns now it will show that marital status has blanks. so, every content those cells are shifted to the r...
excel
Formulas and Functions
  • jitinm's avatar
    jitinm
    Feb 11, 2022
    Remove the filer
    Go to 2nd cycle
    Select the data next to it in D column
    With right click select delete
    Select “shift cells left”

theInsider's avatar
theInsider
Copper Contributor
Feb 10, 2022

jitinm sorry that didn't work . what happened here is that some of the rows contents are shifted to the right eg. the marital status contents  are shifter to the next column in kids_home. I just cannot think of a way to do it as i am not a regular user of excel.

jitinm's avatar
jitinm
Iron Contributor
Feb 11, 2022
If its possible for you to share a sample sheet that would help much
  • theInsider's avatar
    theInsider
    Copper Contributor
    Feb 11, 2022

    jitinm https://learnermanipal-my.sharepoint.com/:x:/g/personal/subhranshu_nayak_learner_manipal_edu/EfoUHzPdhlxKs68wAD0-HnUB6sifNdTPzka-YUFoFQqbSA?e=ueNs9K 

     Here is  the link for the excel file.

     

    thank you for your help.

Resources