Kindly help me in creating the script for this data.

[#1]

Hi,

I have to write a script for this sort of data. how it would be possible?

As this is just a dummy data which i have on my excel sheet.

I have multiple sheets all containting the same number of fields but with different dates.

For the month of JAN					Total
Shift		A	B	C
Calls		14	16	12	42
Follow-up	Later	10	6	10	26
	Not Interested	4	10	2	16
[Day:Tuesday 01/01/2013]

I wrote up this simple script :

LOAD Shift,

            Calls,

            [Follow-up],

            [Day:TUSEDAY 01/01/2013]  as Day

FROM

(ooxml, embedded labels, header is 1 lines, table is [1 JAN], filters(

Transpose(),

));

But Follow-Up fields contain two Sub-fields (Later,Not interested) and kindly help me with the date aswell.

Please help me in creating the correct script.

Thanks..

[sujeetsingh]

Seems i got confussed plz provide a sample.

[#3]

Please review the attached file as i forgot to attach it earlier. i hope so it will be presenting a more clear picture now.

Thanks.

[RedSky001]

See the attached file, let me now of this helps?

Mark

(edit I've attached a version 2, this loops through the work sheets)

[#5]

Many thanks Mark.

You solved my problem to some extent, but still i am unable to lookup the 'Later' and 'Not interested' field, as if we delete the first row after transposing then these two fields will get deleted aswell.

The Follow-up field consists of two different fields "Later and Not-Interested", its more likely hierarchical.

I want to compute these two fields separately.

Seeking guidance from you.

Many thanks again.

Regards,

Hassam

[RedSky001 · Accepted solution]

See V3 attached

[#7]

Thumbs Up.. !!

You solved my problem.

Many thanks again..