Replace 0's with corresponding number in data set

[True]

Hi all, I am looking to replace all 0’s in each data set with the corresponding number in the data set below but keeping the amount of data entries in the top panel. (this is so I can use this for a heatmap)

Thanks!

[René_Corella]

Your data is easy to simulate but you might get scolded soon for not sharing your file

[inno]

Replace Text might work in your case

if that doesn’t work, please follow Renè’s suggestion and upload the gh file to see what’s going on there

[True]

thank you this works perfectly!