Data Cleaning / Sorting Help

[Tylerspears27]

Hi!

I have a spreadsheet that looks like this:

                 Model                                   Model                                   Model

     exterior A  exterior B               exterior A  exterior B           exterior A  exterior B 

     exterior C                                exterior C                             exterior C

     cost           SF                          cost           SF                        cost           SF

1:   $                #                            $               #                          $               #

2:   $                #                            $               #                          $               #

3:   $                #                            $               #                          $               #

All of these reports come in the same way. However some may have more models than the other - is there an easy way to clean this type of data? I would like the output to be cost and SF by each model and exterior (you can have two models with the same exterior and vice versa). Any thoughts?

[v-jiascu-msft]

Hi @Tylerspears27,

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

Best Regards,

Dale

[Tylerspears27]

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?