Rearrange data in excel

[Hyejin Jeon]

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.

[#2]

Hi Hyejin, I think I can help you with the file, no Macro is needed. Could you send me some example of original file in Excel format and the result file ?

Best regards
Zvonimir