Pivot table with two headers in MS Excel

I'd soo appreciate if someone could help.

My initial table looks like this:

Brand Period_1 Period_1 Period_2 Period_2
------------------------------------------------------ New York London New York London
------------------------------------------------------
BrandName_1 123,45 233,23 232,23 393,23
BrandName_2 139,45 202,63 939,38 399,00 

I would like to make a pivot table that should look like this:

 Brand Period_1 Period_2
New York BrandName_1 123,45 232,23 BrandName_2 139,45 939,38
London BrandName_1 233,23 393,23 BrandName_2 202,63 399,00

How can I achieve it in Excel?

Thanks a lot

1 Answer

You need a flat table with these columns and one item per row

city, brand name, Period, amount

Then you can build this pivot table. You won't be able to build it from the table that is already structured like a report.