for data example you shared @elsamuel solution (usage of one Pivoting node) works just fine to get your desired output. Seems to me you are saying that you have some additional columns. Can you maybe share workflow example so we can take a look at what is troubling you? See here how to create reproducible workflow examples: