Yah, I will be changing the names to Jan17, Feb17, etc.
However, I cannot guarantee that this will be the final format.
And yes I was talking about the yellow portion, however I will be doing the same thing for the blue portion.
I used this sheet to give an idea of why I need to do this. But I would really just like to learn the concept on how to do it. I'm not asking you to do it for me. I would like to learn how so I can do it on my own in the future because this is a concept I will be using a lot.
And having a unique identifier column is fine I can call it TX# or something.
Anyways, hopefully that all made sense.