Forum Discussion
Unpivot Columns - Cleaning Up Data
I have an excel table that needs a lot of clean up. I am trying to use unpivot and I am at a total loss of how to even start. My data looks like this: ---------------------------------------DATE1---...
Anonymous ,
Check the attached file.
Hi, Anonymous , the tricky part is to split dates and to assign them to each group of types. You might want to try the steps applied in the attach file.
CNENFRNL ,
Thank you. This solution also works and in fewer steps than the post I accepted as the solution. I selected the other post because they responded first.
Hi, Anonymous , the tricky part is to split dates and to assign them to each group of types. You might want to try the steps applied in the attach file.
CNENFRNL ,
Thank you. This solution also works and in fewer steps than the post I accepted as the solution. I selected the other post because they responded first.