Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

This is an excel question. Okay so I have 2 columns. The…

Customer Question
This is an excel question...
This is an excel question. Okay so I have 2 columns. The first column has a set of sorted numbers. The second column has a set of names that are associated with that number in the first column. The problem is, I want it to make a third and fourth column that has only one number and one person associated with that number. Meaning I want to get rid of all the repeats. Here is an example.

Column A Column B Column C Column D
1 Pete 1 Pete
1 Pete 2 Bob
1 Pete 3 Phill
2 Bob
2 Bob
3 Phill

So Column C and Column D just show one of the numbers from column A the name associated with that number in column D.
Submitted: 8 years ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 3 minutes by:
6/16/2010
Tech Support Specialist: namzyanzy, Computer Support Specialist replied 8 years ago
namzyanzy
namzyanzy, Computer Support Specialist
Category: Computer
Satisfied Customers: 737
Experience: BE, MCSE and over 10+ years of experience in assisting customers with their technical queries
Verified
Hi. Thank you for asking your question on JustAnswer. Could you upload sample file in the link below and then explain what exactly you need:

http://wikisend.com

Send me the link of the file you have uploaded.
Ask Your Own Computer Question
Customer reply replied 8 years ago

It wont let me open this link because my company blocks the website.

 

Work OrderNameWork OrderName
24107140A WILLIAMS 24107140A WILLIAMS
24107140A WILLIAMS 24107190A WILLIAMS
24107140A WILLIAMS 24107180B CANNON
24107140A WILLIAMS 23637070B CAUSEY
24107140A WILLIAMS 23776060B CAUSEY
24107140A WILLIAMS and so on
24107140A WILLIAMS
24107140A WILLIAMS
24107140A WILLIAMS
24107140A WILLIAMS
24107190A WILLIAMS
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
24107180B CANNON
23637070B CAUSEY
23776060B CAUSEY
23834230B CAUSEY
23989870B CAUSEY

 

Let me know if this works. What I want is a code to get the last two columns from the first two columns.

Tech Support Specialist: namzyanzy, Computer Support Specialist replied 8 years ago
We can definitely do that. But I would need the file to work on. I am unable to copy and paste these text into excel. Is there any way you could upload a sample file?
Ask Your Own Computer Question
Customer reply replied 8 years ago
I guess I would have to wait till I get home. I will have to email you back. Thanks,
Tech Support Specialist: namzyanzy, Computer Support Specialist replied 8 years ago
Just send a reply to this post and I will respond.

Edited by namzyanzy on 6/16/2010 at 9:34 PM EST
Ask Your Own Computer Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tech support specialistLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask namzyanzy Your Own Question
namzyanzy
namzyanzy
namzyanzy, Computer Support Specialist
Category: Computer
Satisfied Customers: 737
737 Satisfied Customers
Experience: BE, MCSE and over 10+ years of experience in assisting customers with their technical queries

namzyanzy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Andy

Andy

Computer Consultant

5,316 satisfied customers

11yr exp, Comp Engg, Internet expert, Web developer, SEO

Engineer John C.

Engineer John C.

Computer Science Engineer

3,229 satisfied customers

Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

Ryan H.

Ryan H.

Computer Support Specialist

1,741 satisfied customers

A+ Certified Technician - 10 Years experience working with all types of computer systems.

Jane Lefler

Jane Lefler

Sr Prog Analyst / Technician

2 satisfied customers

Computer Programmer / Technician/ Consultant 16+ years

Frederick S.

Frederick S.

Computer Specialist

7,241 satisfied customers

Computer technician and founder of a home PC repair company.

lifesaver

lifesaver

Computer Software Engineer

4,288 satisfied customers

Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

Sudipto

Sudipto

Hardware Engineer

4,260 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
Penn college need answer now plz Microsoft Word 2016 1. Font
Penn foster college need answer now plz Microsoft Word 2016 1. Font size, font style, and _______ are all aspects of character formatting. A. typeface B. indentation C. line spacing. D. alignment 2. W… read more
Ricky Expert
Ricky Expert
Bachelor\u0027s Degree
1,323 satisfied customers
We are a small wholesale company trying to convert a sales
We are a small wholesale company trying to convert a sales report on excel into a packing list. We require a special way of sorting data, in brief, here is what we are trying to achieve: data for one … read more
Jason Jones
Jason Jones
AAS Information Technology
6,329 satisfied customers
Question about "fill" in MS Office 2010 Excel: How can I get
Question about "fill" in MS Office 2010 Excel: How can I get it to fill in a series of date ranges -- so every cell gives the next week's dates. E.g. Mar 1-Mar 8; Mar 9 - Mar 16; Mar 17-Mar 24; and so… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
I am compiling an address list and need to know the following... How
I am compiling an address list and need to know the following... How can I get the column width to automatically adjust to the length of info in that column? Also, after the names and addresses are en… read more
Frederick S.
Frederick S.
Computer Specialist
High School or GED
7,241 satisfied customers
Sub SnakeCols_test() Parameters for SnakeColsx Hrows
Sub SnakeCols_test() 'Parameters for SnakeColsx 'Hrows = 1 'specify number of heading rows 'Cols = 3 'specify number of cols to copy 'setts = 5 'specify number of sets per page 'rowspp = 43 'specify n… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
I would like to have an Excel 203 spread sheet programmed to
I would like to have an Excel 203 spread sheet programmed to give me a desired read out which would look just like the example I would provide, Somewhat like a graph. Here goes, In column A as you can… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Mail merge I must print multiple records to each customer.
Mail merge: I must print multiple records to each customer. The records are in a chart in the letter. Each customer has a differnt "number of records". What rule will get each letter to each customer … read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
I want to create a sort option for an Excell column. However
I want to create a sort option for an Excell column. However I will have multiple values in a cell to sort from (e.g. A, B, C ). How can I only sort on A without including B & C ?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a worksheet of time, Vx and Vy measured every 2 seconds
I have a worksheet of time, Vx and Vy measured every 2 seconds for a day. I want to chart the average of the previous 5 values every ten seconds.… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
THIS IS A GOOGLE SPREADSHEET QUESTION. I WANT TO SEE AND TOTAL
THIS IS A GOOGLE SPREADSHEET QUESTION. I WANT TO SEE AND TOTAL ALL THE ROWS THAT HAVE SPECIFIC TEXT IN COLUNM A.… read more
Dr. Dan
Dr. Dan
Doctoral Degree
572 satisfied customers
John D. - Please help! Hi John, I have another Excel question.
John D. - Please help! Hi John, I have another Excel question. So here is what I want to do. I have 1 workbook with 2 different worksheets at the bottom. Worksheet #1 is a check register with a column… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
1. You can summarize a range of data using the A. Range Summary
1. You can summarize a range of data using the A. Range Summary shortcut. B. Summarize tab. C. Range tab. D. Convert to Range button. 2. How can you scroll through a worksheet while still viewing the … read more
JHarvAllen
JHarvAllen
Instructor
Bachelor's Degree
8 satisfied customers
I have a document in Microsoft Word 2007 which is a column
I have a document in Microsoft Word 2007 which is a column of 72,900 numbers, which is 1,350 pages long. The column of numbers was created in Microsoft Excel. I need to create from that column of numb… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have an imported worksheet that has rows of data that I want
I have an imported worksheet that has rows of data that I want to remove through a macro. I can sort the data and have numerous rows of data that appears such as row headers, totals etc. How do I writ… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am using microsoft excel 2003 sp3. I have a file that I created
I am using microsoft excel 2003 sp3. I have a file that I created using information from two seperate files. I have 3 columns. The first list customer names ( there might be 3000 or so and each custom… read more
the prof
the prof
computing consultant
Master's Degree
160 satisfied customers
I have an excel workbook with three worksheets. The first
I have an excel workbook with three worksheets. The first worksheet has two columns of SSN's which match a SNN column in one of the other worksheets: (column A SSN / worksheet 1 somewhere in column a … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a set of columns in a worksheet and i want to ...
I have a set of columns in a worksheet and i want to reorganize the data in this workesheet by re-sorting the columns. The number of columns in that sheet is over 20o. How to sort this number of colum… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
how can I formulate for a column to replace a letter
how can I formulate for a column to replace a letter with a number? For example, if A1 = A, i would want it to replace it with the number 1; if A1 = B, I would want it to replace it with the number 2;… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x