Forum

Hi Mynda, Thanks I was missing the transpose step. I have another conundrum of more than two rows to be unpivoted. I have managed to do ...

Hi Alex, Many thanks, It worked. I was missing out the step of splitting the column with Sales and Sales out. Thanks once more. ...

Hi Mynda, Thanks for that. At least it proved I was attentive. In your video you mentioned it shows "Today's date" that is why I got confused....

Hello Alex, I tried that before. May be I was not very clear, the result I am looking for is 5 columns one for Sales, Sales out, Year, Cat an...