I am trying to build a new table using an data from an existing table. Can you please advise what kind of recipe should I use?
I am trying to build a new table, using the table above
I am trying to build a new table of data (the 2nd table in my original message) using an existing dataset (the first table in my original message). I was going to use the GROUP recipe initially but I realized in the new table I am trying to create, I am utilizing different columns (from the first table), so I didn't think the GROUP recipe is going to work.
I have colored coded the numbers between the 1st/2nd table, so that you can visualize what I am trying to achieve in my 2nd table
Hope this makes more sense 🙂