Hello,
I am trying to make a spreadsheet easier to prepare for a mail merge in word. the excel spreadsheet holds information of account number, customer name, email address (with multiples split in the same cell with a ';'), invoice #, date of invoice, amount of invoice.
I can separate the emails using the text to columns, which keeps the addresses in the same row but in their own cell.
What i need is each email to have their own row with the same information captured in the original row bar the email address.
IE:
From this:
JOE123 JOE BLOGGS JOE@JOEBLOGGS.COM JBLOGGS@JOEBLOGGS.COM JOEB@JOEBLOGGS.COM 12345678 23/03/2021 £123.45
To:
JOE123 JOE BLOGGS JOE@JOEBLOGGS.COM 12345678 23/03/2021 £123.45
JOE123 JOE BLOGGS JBLOGGS@JOEBLOGGS.COM 12345678 23/03/2021 £123.45
JOE123 JOE BLOGGS JOEB@JOEBLOGGS.COM 12345678 23/03/2021 £123.45
I am trying to make a spreadsheet easier to prepare for a mail merge in word. the excel spreadsheet holds information of account number, customer name, email address (with multiples split in the same cell with a ';'), invoice #, date of invoice, amount of invoice.
I can separate the emails using the text to columns, which keeps the addresses in the same row but in their own cell.
What i need is each email to have their own row with the same information captured in the original row bar the email address.
IE:
From this:
JOE123 JOE BLOGGS JOE@JOEBLOGGS.COM JBLOGGS@JOEBLOGGS.COM JOEB@JOEBLOGGS.COM 12345678 23/03/2021 £123.45
To:
JOE123 JOE BLOGGS JOE@JOEBLOGGS.COM 12345678 23/03/2021 £123.45
JOE123 JOE BLOGGS JBLOGGS@JOEBLOGGS.COM 12345678 23/03/2021 £123.45
JOE123 JOE BLOGGS JOEB@JOEBLOGGS.COM 12345678 23/03/2021 £123.45