I have attached the file here for reference.
If for a particular year of data (in this case, FY 2012), I have two columns - one's "original", and one's "restated", how do I write up a code such that the system would pick up "restated", and delete "original"? But for the other years that ONLY have "original" date, I want to keep those columns.
Could you advise on this multiple criteria?
Bookmarks