Result:
load
  ID
  ,SubField(TimeLine,'|',1) as InA
  ,SubField(TimeLine,'|',2) as OutA
  ,SubField(TimeLine,'|',3) as InB
  ,SubField(TimeLine,'|',4) as OutB
  ,SubField(TimeLine,'|',5) as InC
  ,SubField(TimeLine,'|',6) as OutC
  ,SubField(TimeLine,'|',7) as InD
  ,SubField(TimeLine,'|',8) as OutD
  ,if(len(SubField(TimeLine,'|',9)),'Yes') as ExtraDataIgnored;
load ID ,concat(TimeIn & '|' & TimeOut, '|',TimeIn) as TimeLine
Resident SourceData
Group by ID;

If TimeIn isn't a numeric field then use the time# function to make a time value of it first so it can be used in the concat function as sort field.