Thread: Change the shape of data from one format to another

Hi all,

I have an issue changing the format of data from one format to another.

I have created a sample file (attached) of the data showing the two formats. I am really struggling with the formulas.

Can some of you excel supremo's out there help me.

Rgds
Okanem