Need help with non column report
Hi everyone. Very new to Monarch. I am trying to extract data from the following report format. How can I get the info into a single line? Everything I tried picks up each individual field as a separate item in the table. I would like for each block to be one record with the fields as Employee#, LAST NAME, etc. Thanks for your help
DATE 04/20/17 EMPLOYEE INFO PAGE 1
--------------------------------------------------------------------------------------------------------------------
EMPLOYEE #.................. NNNN(N)
LAST NAME.................... XXXXXXXXXXXXXXXXXXXX
FIRST NAME................... XXXXXXXXXXXXXXXXXXXX
DEPARTMENT CODE..... NNNN
............................................................................................................................................
DATE 04/20/17 EMPLOYEE INFO PAGE
--------------------------------------------------------------------------------------------------------------------
EMPLOYEE #.................. XXXXX
LAST NAME.................... XXXXXXXXXXXXXXXXXXXX
FIRST NAME................... XXXXXXXXXXXXXXXXXXXX