See the attached file, let me now of this helps?
(edit I've attached a version 2, this loops through the work sheets)
Example V2.qvw 151.5 K
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.