Find and move only the email addresses from one column to another
I have a client list that contains name, address, city, state, zip code, but some randomly have an email address instead of a street address.
I need to move the email address out of the address column into a separate column on the same worksheet but still associated with the same client record.
The only constant is the "@" in the email addresses. Is there a way to do this without going through each individual client record and moving them one by one?
EDIT:
Here is a sample of the data:
How do I identify only the email addresses and move them to column I?
microsoft-excel worksheet-function
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
asked Dec 12 '18 at 15:47
Kari Carpenter
61
add a comment |
I have a client list that contains name, address, city, state, zip code, but some randomly have an email address instead of a street address.
I need to move the email address out of the address column into a separate column on the same worksheet but still associated with the same client record.
The only constant is the "@" in the email addresses. Is there a way to do this without going through each individual client record and moving them one by one?
EDIT:
Here is a sample of the data:
How do I identify only the email addresses and move them to column I?
microsoft-excel worksheet-function
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
asked Dec 12 '18 at 15:47
Kari Carpenter
61
2
you need to share some good sample data for us to help with this, and what the output will look like
– PeterH
Dec 12 '18 at 15:50
Good point. Here is a sample of the data.
– Kari Carpenter
Dec 12 '18 at 19:09
Good point. Here is a sample of the data. Column A: Customer Name, Column B: Phone Number, Column C:# of Invoices, Column D: Invoice Total, Column E: Hours, Column F: is Address Line 1, Column G: Address Line 2, Column H: Address Line 3. EX: COLUMN F -- F2:123 Main Street, F3:johndoe@email.com, F4: blank. Each ROW is a different customer. How do I identify only the email addresses and move them to column H? Sorry, I don't know how to put a sample data sheet in here.
– Kari Carpenter
Dec 12 '18 at 19:24
@KariCarpenter,, Y you are looking to moveMail IdstoCol Hsince theColumn H is already occupied by Address line 3,, ?
– Rajesh S
Dec 13 '18 at 9:56
The simplest way to show sample data is to take a screenshot, upload it to imgur.com and paste the link in your question. Typically, other users will then edit your question and inline the image. Once you reach 10 reputation, you will be able to directly paste the screenshot into your question. Note that any extra info you add must be placed in the question itself by editing it, and not posted in a comment.
– robinCTS
Dec 13 '18 at 13:02
add a comment |
I have a client list that contains name, address, city, state, zip code, but some randomly have an email address instead of a street address.
I need to move the email address out of the address column into a separate column on the same worksheet but still associated with the same client record.
The only constant is the "@" in the email addresses. Is there a way to do this without going through each individual client record and moving them one by one?
EDIT:
Here is a sample of the data:
How do I identify only the email addresses and move them to column I?
microsoft-excel worksheet-function
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
asked Dec 12 '18 at 15:47
Kari Carpenter
61
I have a client list that contains name, address, city, state, zip code, but some randomly have an email address instead of a street address.
I need to move the email address out of the address column into a separate column on the same worksheet but still associated with the same client record.
The only constant is the "@" in the email addresses. Is there a way to do this without going through each individual client record and moving them one by one?
EDIT:
Here is a sample of the data:
How do I identify only the email addresses and move them to column I?
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
asked Dec 12 '18 at 15:47
Kari Carpenter
61
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
asked Dec 12 '18 at 15:47
Kari Carpenter
61
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
edited Dec 13 '18 at 12:49
robinCTS
4,00841527
4,00841527
asked Dec 12 '18 at 15:47
Kari Carpenter
61
asked Dec 12 '18 at 15:47
Kari Carpenter
61
asked Dec 12 '18 at 15:47
Kari Carpenter
61
61
2
you need to share some good sample data for us to help with this, and what the output will look like
– PeterH
Dec 12 '18 at 15:50
Good point. Here is a sample of the data.
– Kari Carpenter
Dec 12 '18 at 19:09
Good point. Here is a sample of the data. Column A: Customer Name, Column B: Phone Number, Column C:# of Invoices, Column D: Invoice Total, Column E: Hours, Column F: is Address Line 1, Column G: Address Line 2, Column H: Address Line 3. EX: COLUMN F -- F2:123 Main Street, F3:johndoe@email.com, F4: blank. Each ROW is a different customer. How do I identify only the email addresses and move them to column H? Sorry, I don't know how to put a sample data sheet in here.
– Kari Carpenter
Dec 12 '18 at 19:24
@KariCarpenter,, Y you are looking to moveMail IdstoCol Hsince theColumn H is already occupied by Address line 3,, ?
– Rajesh S
Dec 13 '18 at 9:56
The simplest way to show sample data is to take a screenshot, upload it to imgur.com and paste the link in your question. Typically, other users will then edit your question and inline the image. Once you reach 10 reputation, you will be able to directly paste the screenshot into your question. Note that any extra info you add must be placed in the question itself by editing it, and not posted in a comment.
– robinCTS
Dec 13 '18 at 13:02
add a comment |
2
you need to share some good sample data for us to help with this, and what the output will look like
– PeterH
Dec 12 '18 at 15:50
Good point. Here is a sample of the data.
– Kari Carpenter
Dec 12 '18 at 19:09
Good point. Here is a sample of the data. Column A: Customer Name, Column B: Phone Number, Column C:# of Invoices, Column D: Invoice Total, Column E: Hours, Column F: is Address Line 1, Column G: Address Line 2, Column H: Address Line 3. EX: COLUMN F -- F2:123 Main Street, F3:johndoe@email.com, F4: blank. Each ROW is a different customer. How do I identify only the email addresses and move them to column H? Sorry, I don't know how to put a sample data sheet in here.
– Kari Carpenter
Dec 12 '18 at 19:24
@KariCarpenter,, Y you are looking to moveMail IdstoCol Hsince theColumn H is already occupied by Address line 3,, ?
– Rajesh S
Dec 13 '18 at 9:56
The simplest way to show sample data is to take a screenshot, upload it to imgur.com and paste the link in your question. Typically, other users will then edit your question and inline the image. Once you reach 10 reputation, you will be able to directly paste the screenshot into your question. Note that any extra info you add must be placed in the question itself by editing it, and not posted in a comment.
– robinCTS
Dec 13 '18 at 13:02
2
2
you need to share some good sample data for us to help with this, and what the output will look like
– PeterH
Dec 12 '18 at 15:50
you need to share some good sample data for us to help with this, and what the output will look like
– PeterH
Dec 12 '18 at 15:50
Good point. Here is a sample of the data.
– Kari Carpenter
Dec 12 '18 at 19:09
Good point. Here is a sample of the data.
– Kari Carpenter
Dec 12 '18 at 19:09
Good point. Here is a sample of the data. Column A: Customer Name, Column B: Phone Number, Column C:# of Invoices, Column D: Invoice Total, Column E: Hours, Column F: is Address Line 1, Column G: Address Line 2, Column H: Address Line 3. EX: COLUMN F -- F2:123 Main Street, F3:johndoe@email.com, F4: blank. Each ROW is a different customer. How do I identify only the email addresses and move them to column H? Sorry, I don't know how to put a sample data sheet in here.
– Kari Carpenter
Dec 12 '18 at 19:24
Good point. Here is a sample of the data. Column A: Customer Name, Column B: Phone Number, Column C:# of Invoices, Column D: Invoice Total, Column E: Hours, Column F: is Address Line 1, Column G: Address Line 2, Column H: Address Line 3. EX: COLUMN F -- F2:123 Main Street, F3:johndoe@email.com, F4: blank. Each ROW is a different customer. How do I identify only the email addresses and move them to column H? Sorry, I don't know how to put a sample data sheet in here.
– Kari Carpenter
Dec 12 '18 at 19:24
@KariCarpenter,, Y you are looking to move
Mail Ids to Col H since the Column H is already occupied by Address line 3,, ?– Rajesh S
Dec 13 '18 at 9:56
@KariCarpenter,, Y you are looking to move
Mail Ids to Col H since the Column H is already occupied by Address line 3,, ?– Rajesh S
Dec 13 '18 at 9:56
The simplest way to show sample data is to take a screenshot, upload it to imgur.com and paste the link in your question. Typically, other users will then edit your question and inline the image. Once you reach 10 reputation, you will be able to directly paste the screenshot into your question. Note that any extra info you add must be placed in the question itself by editing it, and not posted in a comment.
– robinCTS
Dec 13 '18 at 13:02
The simplest way to show sample data is to take a screenshot, upload it to imgur.com and paste the link in your question. Typically, other users will then edit your question and inline the image. Once you reach 10 reputation, you will be able to directly paste the screenshot into your question. Note that any extra info you add must be placed in the question itself by editing it, and not posted in a comment.
– robinCTS
Dec 13 '18 at 13:02
add a comment |
3 Answers
3
active
oldest
votes
This is actually quite straightforward to do.
Step 1
Turn on AutoFiltering using one of these methods:
Data→Sort & Filter→Filter
Alt+(A; T)
Ctrl+Shift+L
Step 2
Filter the Address Line 1 column with a contains @ custom text filter created via the down control arrow:
Step 3
Select the filtered cells of the Address Line 1 column that contain email addresses (the simplest way is to select the topmost cell and press Ctrl+Shift+Down), extend the selection to encompass the other address columns and the email column ( Shift+(Right;Right; Right) ), and then fill right using one of the following methods:
Home→Editing→Fill→Right
Alt+(H; F; I; R)
Ctrl+R
Step 4
Reduce the selection by one column (Shift+Left), and then press Delete to clear all the address columns:
Step 5
Finally, turn off AutoFiltering in the same way you turned it on, e.g. Alt+(A; T):
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
add a comment |
Hopefully, I'm understanding your question correctly. Is all that information currently stored in just 1 column? A bit like this?
If so, you can use Data > Text to Columns to split them out into separate columns. In my example, I'm using 'comma' as the 'delimiter'(example) but it would work with spaces and so on depending on your data.
Here's what the output might look like after completing the wizard.
Output
edited Dec 13 '18 at 14:26
Burgi
3,84192542
answered Dec 12 '18 at 15:56
Berty_Lurch
1
add a comment |
If you are using Excel version 2016 or higher, then you may use this Formula:
=TEXTJOIN(", ", TRUE, IF(ISERROR(SEARCH("@", A2:A6)), "", A2:A6))
You may use this Array Formula if using lower version than 2016:
{=IFERROR(INDEX(A2:A6, 1, MIN(IF(ISERROR(SEARCH("@", A2:A6)), "", MATCH(ROW(A2:A6),ROW(A2:A6))))),"")}
Note:
- Finish this Formula with
Ctrl+Shift+Enter. - Adjust cell references in the Formula as needed.
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1383009%2ffind-and-move-only-the-email-addresses-from-one-column-to-another%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
This is actually quite straightforward to do.
Step 1
Turn on AutoFiltering using one of these methods:
Data→Sort & Filter→Filter
Alt+(A; T)
Ctrl+Shift+L
Step 2
Filter the Address Line 1 column with a contains @ custom text filter created via the down control arrow:
Step 3
Select the filtered cells of the Address Line 1 column that contain email addresses (the simplest way is to select the topmost cell and press Ctrl+Shift+Down), extend the selection to encompass the other address columns and the email column ( Shift+(Right;Right; Right) ), and then fill right using one of the following methods:
Home→Editing→Fill→Right
Alt+(H; F; I; R)
Ctrl+R
Step 4
Reduce the selection by one column (Shift+Left), and then press Delete to clear all the address columns:
Step 5
Finally, turn off AutoFiltering in the same way you turned it on, e.g. Alt+(A; T):
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
add a comment |
This is actually quite straightforward to do.
Step 1
Turn on AutoFiltering using one of these methods:
Data→Sort & Filter→Filter
Alt+(A; T)
Ctrl+Shift+L
Step 2
Filter the Address Line 1 column with a contains @ custom text filter created via the down control arrow:
Step 3
Select the filtered cells of the Address Line 1 column that contain email addresses (the simplest way is to select the topmost cell and press Ctrl+Shift+Down), extend the selection to encompass the other address columns and the email column ( Shift+(Right;Right; Right) ), and then fill right using one of the following methods:
Home→Editing→Fill→Right
Alt+(H; F; I; R)
Ctrl+R
Step 4
Reduce the selection by one column (Shift+Left), and then press Delete to clear all the address columns:
Step 5
Finally, turn off AutoFiltering in the same way you turned it on, e.g. Alt+(A; T):
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
add a comment |
This is actually quite straightforward to do.
Step 1
Turn on AutoFiltering using one of these methods:
Data→Sort & Filter→Filter
Alt+(A; T)
Ctrl+Shift+L
Step 2
Filter the Address Line 1 column with a contains @ custom text filter created via the down control arrow:
Step 3
Select the filtered cells of the Address Line 1 column that contain email addresses (the simplest way is to select the topmost cell and press Ctrl+Shift+Down), extend the selection to encompass the other address columns and the email column ( Shift+(Right;Right; Right) ), and then fill right using one of the following methods:
Home→Editing→Fill→Right
Alt+(H; F; I; R)
Ctrl+R
Step 4
Reduce the selection by one column (Shift+Left), and then press Delete to clear all the address columns:
Step 5
Finally, turn off AutoFiltering in the same way you turned it on, e.g. Alt+(A; T):
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
This is actually quite straightforward to do.
Step 1
Turn on AutoFiltering using one of these methods:
Data→Sort & Filter→Filter
Alt+(A; T)
Ctrl+Shift+L
Step 2
Filter the Address Line 1 column with a contains @ custom text filter created via the down control arrow:
Step 3
Select the filtered cells of the Address Line 1 column that contain email addresses (the simplest way is to select the topmost cell and press Ctrl+Shift+Down), extend the selection to encompass the other address columns and the email column ( Shift+(Right;Right; Right) ), and then fill right using one of the following methods:
Home→Editing→Fill→Right
Alt+(H; F; I; R)
Ctrl+R
Step 4
Reduce the selection by one column (Shift+Left), and then press Delete to clear all the address columns:
Step 5
Finally, turn off AutoFiltering in the same way you turned it on, e.g. Alt+(A; T):
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
edited Dec 13 '18 at 12:33
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
answered Dec 13 '18 at 9:26
robinCTS
4,00841527
4,00841527
add a comment |
add a comment |
Hopefully, I'm understanding your question correctly. Is all that information currently stored in just 1 column? A bit like this?
If so, you can use Data > Text to Columns to split them out into separate columns. In my example, I'm using 'comma' as the 'delimiter'(example) but it would work with spaces and so on depending on your data.
Here's what the output might look like after completing the wizard.
Output
edited Dec 13 '18 at 14:26
Burgi
3,84192542
answered Dec 12 '18 at 15:56
Berty_Lurch
1
add a comment |
Hopefully, I'm understanding your question correctly. Is all that information currently stored in just 1 column? A bit like this?
If so, you can use Data > Text to Columns to split them out into separate columns. In my example, I'm using 'comma' as the 'delimiter'(example) but it would work with spaces and so on depending on your data.
Here's what the output might look like after completing the wizard.
Output
edited Dec 13 '18 at 14:26
Burgi
3,84192542
answered Dec 12 '18 at 15:56
Berty_Lurch
1
add a comment |
Hopefully, I'm understanding your question correctly. Is all that information currently stored in just 1 column? A bit like this?
If so, you can use Data > Text to Columns to split them out into separate columns. In my example, I'm using 'comma' as the 'delimiter'(example) but it would work with spaces and so on depending on your data.
Here's what the output might look like after completing the wizard.
Output
edited Dec 13 '18 at 14:26
Burgi
3,84192542
answered Dec 12 '18 at 15:56
Berty_Lurch
1
Hopefully, I'm understanding your question correctly. Is all that information currently stored in just 1 column? A bit like this?
If so, you can use Data > Text to Columns to split them out into separate columns. In my example, I'm using 'comma' as the 'delimiter'(example) but it would work with spaces and so on depending on your data.
Here's what the output might look like after completing the wizard.
Output
edited Dec 13 '18 at 14:26
Burgi
3,84192542
answered Dec 12 '18 at 15:56
Berty_Lurch
1
edited Dec 13 '18 at 14:26
Burgi
3,84192542
edited Dec 13 '18 at 14:26
Burgi
3,84192542
edited Dec 13 '18 at 14:26
Burgi
3,84192542
3,84192542
answered Dec 12 '18 at 15:56
Berty_Lurch
1
answered Dec 12 '18 at 15:56
Berty_Lurch
1
answered Dec 12 '18 at 15:56
Berty_Lurch
1
1
add a comment |
add a comment |
If you are using Excel version 2016 or higher, then you may use this Formula:
=TEXTJOIN(", ", TRUE, IF(ISERROR(SEARCH("@", A2:A6)), "", A2:A6))
You may use this Array Formula if using lower version than 2016:
{=IFERROR(INDEX(A2:A6, 1, MIN(IF(ISERROR(SEARCH("@", A2:A6)), "", MATCH(ROW(A2:A6),ROW(A2:A6))))),"")}
Note:
- Finish this Formula with
Ctrl+Shift+Enter. - Adjust cell references in the Formula as needed.
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
add a comment |
If you are using Excel version 2016 or higher, then you may use this Formula:
=TEXTJOIN(", ", TRUE, IF(ISERROR(SEARCH("@", A2:A6)), "", A2:A6))
You may use this Array Formula if using lower version than 2016:
{=IFERROR(INDEX(A2:A6, 1, MIN(IF(ISERROR(SEARCH("@", A2:A6)), "", MATCH(ROW(A2:A6),ROW(A2:A6))))),"")}
Note:
- Finish this Formula with
Ctrl+Shift+Enter. - Adjust cell references in the Formula as needed.
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
add a comment |
If you are using Excel version 2016 or higher, then you may use this Formula:
=TEXTJOIN(", ", TRUE, IF(ISERROR(SEARCH("@", A2:A6)), "", A2:A6))
You may use this Array Formula if using lower version than 2016:
{=IFERROR(INDEX(A2:A6, 1, MIN(IF(ISERROR(SEARCH("@", A2:A6)), "", MATCH(ROW(A2:A6),ROW(A2:A6))))),"")}
Note:
- Finish this Formula with
Ctrl+Shift+Enter. - Adjust cell references in the Formula as needed.
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
If you are using Excel version 2016 or higher, then you may use this Formula:
=TEXTJOIN(", ", TRUE, IF(ISERROR(SEARCH("@", A2:A6)), "", A2:A6))
You may use this Array Formula if using lower version than 2016:
{=IFERROR(INDEX(A2:A6, 1, MIN(IF(ISERROR(SEARCH("@", A2:A6)), "", MATCH(ROW(A2:A6),ROW(A2:A6))))),"")}
Note:
- Finish this Formula with
Ctrl+Shift+Enter. - Adjust cell references in the Formula as needed.
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
answered Dec 14 '18 at 12:03
Rajesh S
3,7021522
3,7021522
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1383009%2ffind-and-move-only-the-email-addresses-from-one-column-to-another%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
you need to share some good sample data for us to help with this, and what the output will look like
– PeterH
Dec 12 '18 at 15:50
Good point. Here is a sample of the data.
– Kari Carpenter
Dec 12 '18 at 19:09
Good point. Here is a sample of the data. Column A: Customer Name, Column B: Phone Number, Column C:# of Invoices, Column D: Invoice Total, Column E: Hours, Column F: is Address Line 1, Column G: Address Line 2, Column H: Address Line 3. EX: COLUMN F -- F2:123 Main Street, F3:johndoe@email.com, F4: blank. Each ROW is a different customer. How do I identify only the email addresses and move them to column H? Sorry, I don't know how to put a sample data sheet in here.
– Kari Carpenter
Dec 12 '18 at 19:24
@KariCarpenter,, Y you are looking to move
Mail IdstoCol Hsince theColumn H is already occupied by Address line 3,, ?– Rajesh S
Dec 13 '18 at 9:56
The simplest way to show sample data is to take a screenshot, upload it to imgur.com and paste the link in your question. Typically, other users will then edit your question and inline the image. Once you reach 10 reputation, you will be able to directly paste the screenshot into your question. Note that any extra info you add must be placed in the question itself by editing it, and not posted in a comment.
– robinCTS
Dec 13 '18 at 13:02