Line Up Multi-Line Records

By using this tool it is possible to integrate in one single row all those records containing fields below in one or more adjacent lines.  

After selecting the entire data area, you should select those columns containing fields below and by doing so, a data pattern will be created. Data pattern will be recognized by this tool and the reformatting process will be able to achieve.

view demo