7 Replies Latest reply on Feb 14, 2019 6:57 PM by Richie Berlin

    I need help in displaying the attached output

    Richie Berlin

      Hello Everyone!

       

      I want to reference S1 and S3 to S2 and fetch the matched records aswell as the unmatched records from S1 and S3,
      Let me know if the " , " separated value in S3 sheet, should be made into additional rows, also the Data source is excel files.

       

       

       

       

      S1

       

      CR#1Release dateProduct nameLeadDomain
      CR00101-02-2019soapRicAA
      CR00220-02-2019dishVicBB
      CR00302-21-2019foodmicDD
      CR00422-02-2019spraypersEE
      CR00523-02-2019carmikFF
      CR00624-02-2019bikedavGG

       

      S2

       

      CR2 NumberCheckpoint
      CR3Complete
      CR4Incomplete
      CR5Complete
      CR6Incomplete
      CR7Complete
      CR8Incomplete
      CR9Complete
      CR10Incomplete
      CR11Complete
      CR12Incomplete

       

      S3

        

       

         

      CR#3CR no3CCLead
      CR0036CR007CCRic
      CR008CR0030CCVic
      CR0020, CR009, CR21CR0031CCmic
      CR10, CR0023CR0032CCpers
      CR0011CR0033CCmik
      CR0037CR0012CCpers
      CR0013CR0035CCmic
      CR0055CR0080CCpers

       

      Desired output

       

        

      CR#1Release dateProduct nameLeadDomainCR no3Checkpoint
      CR00101-02-2019soapRicAA
      CR00220-02-2019dishVicBBCheckpoint1
      CR00302-21-2019foodmicDDComplete
      CR00422-02-2019spraypersEEIncomplete
      CR00523-02-2019carmikFFComplete
      CR00624-02-2019bikedavGGIncomplete
      CR0036RicCCCR007Complete
      CR008VicCCCR0030Incomplete
      CR0020, CR009, CR21micCCCR0031Complete
      CR10, CR0023persCCCR0032Incomplete
      CR0011mikCCCR0033Incomplete
      CR0037persCCCR0012Incomplete
      CR0013micCCCR0035
      CR0055persCCCR0080

       

       

       

      If null data, show it as blank " "


      Would really appreciate your help.

       

      Thanks.

       

      Message was edited by: Richie Berlin i have cleansed the data, let me know if I should be making the " , " separated additional row or this is fine.