Dear all,

Pls kindly help ... Many thanks!

Col A - Code no
Col B - Headers & Information
Col C onwards - Job no
e.g Col C - Job no 1
Col D - Job no 2

With attached file, it shows that each job no. has different information
(i.e will not contain info of ALL Headers), some are missings and therefore
leave blank cells there. My problem is... how to write the remarks " No records" for each job show there ? (the job no. is not fixed, there may be job no 3 in Col E, job no 4 in Col F if required)

Regards.