Forum Discussion

Tylerspears27's avatar
Tylerspears27
Regular Visitor
8 years ago

Data Cleaning / Sorting Help

Hi!   I have a spreadsheet that looks like this:                    Model                                   Model                                   Model      exterior A  exterior B             ...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Tylerspears27,

 

Is your spreadsheet like below? I afraid it's hard to clean. Why are these "exterior *" in the header?

Data_Cleaning

 

Best Regards,

Dale

  • Tylerspears27's avatar
    Tylerspears27
    Regular Visitor
    8 years ago

    Yes. That is correct - It is just how the report is generated making it very tough to clean and upload. 

     

    I am thinking of deleted those exterior rows out then to reference back to another sheet that has a list of all models with all exteriors from that source. Does this make sense & will work?