Hello,
I have a large spread sheet (A2:CB656). I have already created a pivot table with my columns representing "species" and rows representing "site location". This table has been completed but I am now wanting to look at presence/absence for each species at a given site. I am wanting to take the cells with numbers ">0" and replacing it with a "1". Any suggestions?
Thanks
Bookmarks