concat

[Bubskim]

Please help me combine two emails into one so they show as one in my chart.

exampleemail

exampleemail@example.com

^ I would like these two above to show as exampleemail and be grouped together 

[rutger_jansen]

That's sample data. You might be taking yours from a database or flat file. In that case you put the following lines ('Preceding load'):

LOAD
subfield([email], '@', 1) as [fixed_email],
*;

above the load statement, e.g. for an Excel file:

LOAD
subfield([email], '@', 1) as [fixed_email],
*;
email:
LOAD
email, size
FROM
[..\emails.xlsx]
(ooxml, embedded labels, table is Sheet1);

or from a database:

LOAD
subfield([email], '@', 1) as [fixed_email],
*;
SQL Select
email, size
from database.table;

or for 

[Brett_Bleess]

Kimberly, did Rutger's final solution work for you?  If so, please be sure to give credit by using the Accept as Solution button on the post that best helped with things.  If you came up with a different solution, please consider posting that and mark it as the accepted solution so others will know for sure what worked in this case...

Regards,
Brett