Hi, I am not sure I quite understand the layout of your raw data, and
desired output. Is it now every new "section" starts with a line
beginning with this?

==========PDI

And then you want

PDI Number in column A, Finding Category, Reference, Description in
columns B-D,
and then the For example concatenation in column E?


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=374110