June 30 (Reuters) - U.S. President Donald Trump said on Tuesday that Pierre Yared, who has been heading the White House Council of Economic Advisers, will leave that post and return to his role as a professor at Columbia University.