two headers

[KumaRan]

Hi all. Hi all. Here i have excel with two header. i need to do data modelling in this. can anybody help in this?Here i have excel with two header. i need to do data modelling in this. can anybody help in this?

[enriquem]

Hi,

I recommended you load 2 times your data with each header OR build a copy and clean your data in some sheet to set the information by header maybe.

Regards

[KumaRan]

Kindly Can you eloborate it with my sample data with script?

[enriquem]

Here you have

Regards

[KumaRan]

Hi mora,

What you meant to say?

[enriquem]

You couldn't see the example?

[KumaRan]

Ya i couldn't see any example

[KumaRan]

i can see now.thank you

[petter]

Actually there are more than two headers in your sample data. What kind of data modeling are you looking for? What kind of analysis and visualizations do you want to do?

[KumaRan]

Month	Model	Sub model	Quantity
Apr 09	mini		2
	Std		3
	High Grade		5
	Piano		6
	Other		9
	Indian	CTK 860 IN	2
		CTK 6300 IN	1
		CTK 7300 IN	4

i want to get the modelwise quantity for that musical instruments