Rearrange data in excel

Hi,

I am trying to rearrange the excel structure.

I want to make store 1,2,3,4,5,6,7 as column and put all price under the column.

So I want to make first picture like second picture.

Is there any macro that I can use?

Below is where I am now.

Below is the figure that I wanted to be.

I tried to google and use similar macro but none of them worked.

Thank you for your help in advance.