Multiple Rows into Separate Columns

Summary

We are trying to extract job submission work experiences into Separate Columns

Content

Example Data-Work Experience

Recent Position    Start Date      End Date         Job Title              Current Job Title   Job Title 2        Job Title 2      

No                         1/1/2013       5/12/2014          Cashier

No                         8/1/2014       6/1/2015           Car Consultant

Yes                        7/2015                                     Specialist

 

We plan to place each Job Title in a Column Separately as Current Job Title, Job Title 2 and Job Title 2