Forum Discussion
Extract a subset of data from one sheet and copy to another sheet
I have a spreadsheet with 10 columns (first name, last name, Street, town, zip etc) and 40,000 rows of names. This is a list of registered voters. I want to search for specific names of folks Who h...
I've seen the data and Last Name is located in column B. Just to get your question clearly, do you imply you want to copy all the Last Name from column B to another sheet? If yes, all you need to do is select all that values by executing CTRL + SHIFT + Down Arrow from cell B2. Then CTRL + C to copy. Click on the plus sheet icon to open a new sheet and CTRL + V to Paste.
In another way, if you want to combine Last Name and First Name together:
1. You can use Flash Fill, CONCATENATE, CONCAT or & to join.
Let me know if this is what you want or not... The
In another way, if you want to combine Last Name and First Name together:
1. You can use Flash Fill, CONCATENATE, CONCAT or & to join.
Let me know if this is what you want or not... The
I want to search for a dozen names. When these dozen names are found I want to select the name and all the data in the row (last name, first name, Middle, suffix etc etc) and copy this info to a new sheet. I want to do this for the dozen names at one time not by individual name.