arranging in one column to mirror data in another column

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

Guest

I'm being asked to create a "master spreadsheet" that includes information
for over 500 school districts. I'm bringing together several different data
sets into one sheet. I'm arranging data by hand, which is time consuming.
How can I arrange data in one column to exactly match data in another column?
That is, with two columns:

Column 1 Column 2 -a function that will do the following-
Column 2
School A School B
School A
School B School A
School B
School C School C
School C
 
Can you be a little more specfic? I am sorry I do not understand what
you are trying to acomplish by the "diagram" you provided. Thank you.
 
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

merging data from 2 spreadsheets 3
Changing column reference for number of formulas at once 1
RN copy data from workbook to workbook 1
Transpose & Split a Column into multiple Rows 3
Multiple make table queries in one? 3
Need help Excel 2002 compare function 4
Find Mismatched Data 5
Finding within 1 column 9

Back
Top