It is easily doable with Tableau prep, you'll just have to do a pivot on A19 and B19 column in spreadsheet 2. Second step would be to do a left join on spreadsheet 2 to spreadsheet 1.
1 of 1 people found this helpful
Hope you are doing good.
For your desired solution do the following:
1. Pivot the two columns A19 and B19, this will lead to a column just like your "batch" one.
2. Now do left join on these taking spreadsheet 1 as your left table.
Hope this helps.
Thank you very much. I ran into a number of row restrictions but I was able to get around that by first adding more rows on the top right hand corner and then moving the columns (Batch names) into the pivot.
Thank you shristi. This helped me.