Hi

This thread was v useful as I was trying to do exactly the same.

However, I have a problem. The table I am using is very large so when I
run this process I require more rows than are available therfore I have
to take chunks of the data and copy and paste as I go to get it to fit
in a worksheet.

However, I think this can be resolved as the table contains a large
number of blanks which I am not interested in and so can ignore when
creating the list.

Is there a way that when I create the pivot table / list so that all
the blanks are ignored?

Thanks, Paul


--
frankybenali
------------------------------------------------------------------------
frankybenali's Profile: http://www.excelforum.com/member.php...o&userid=18707
View this thread: http://www.excelforum.com/showthread...hreadid=342410