Have tried INDEX, MATCH and still not successful

[Sanjusterr]

I need the data in the input tab show as in the output tab. I found some VB code to repeat the Unique IDs based on number of codes in each row but unable to get the format I have in the output tab. Any help is appreciated. Thanks.

 

[John Jairo V]

Hi @Sanjusterr

Please clarify the following: the number of codes sometimes does not match the amount of code you have on the right (Ex: CDE has the number 3 in column B, but you have 4 codes into columns C:AG). Should respect the number of codes that are in the B column of the Input sheet should be placed or codes that appear distributed per day between columns C:AG ?

Blessings!

 

[Sanjusterr]

I added the 4th code for CDE after I used COUNTA() to determine number of values in the row which was 3 originally. It's an error.

It should be the codes in col D:AH that appear in the output tab. I am trying to reconcile input tab data with another file. The other file has the data as shown in output tab.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Sanjusterr]

Thanks Narayan. This is great.