Remove data from certain rows and place in new row or spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a long list of data, approximately 5000+ rows. I also have a second
list of data that was derived from the first list by an outside source. I
want to take the 2nd list and bump it up to the 1st list and tell excel to
cut the data from that row and place it in another spreadsheet ideally, or
another area.
 
If I understand teh question the first list has "extra' data?

Help > VLookup

lookup name from second list and deliver the other information from that
name's row to the new area
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a list that places data in 3 colmuns (cells) from mult row/ 1
Function in Excel to count and list number of entries of text valuesin a row. 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
comparing data in different rows 4
Losing rows that reference data from another worsheet 1
Collate data from one spreadsheet into another spreadsheet 2
Sorting and grouping data with varying number or rows 1
Copy info from one excel spreadsheet to an excel template 2

Back
Top