There is not enough information in the question to understand why a database table would be designed this way and what other rows are in the table that might need to be selected in a similar manner. Nevertheless, below is a Microsoft SQL Server
statement that will concatenate the two rows in the manner that you specified in your question to create an email address.
Select (Select RTRIM(EMAIL) from table_1 where ID='EMAIL01') + (Select RTRIM(EMAIL) from table_1 where ID='EMAIL01A')
Note: Tested using Microsoft SQL Server Management Studio on SQL Server Express 2012