excel pivot table

[#1]

Hi,

Can someone help me with the following excel structure?

I need to read this into qlikview.

		Historic			LU
Country	Product	Q1/05	Q2/05	Q3/05	Q1/05	Q2/05
Belgium	Xeplion	123	234	345	456	567
Germany	Xeplion	123	234	345	456	567
Belgium	Stelare	234	345	456	567	678

[#2]

This is the easiest way to read it in qlikview but not for the user who provides the data.