Software

Ask Software Development Questions and Get Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Hallo i am a data analyst working with a set of data on a…

Customer Question
Hallo i am a...

Hallo i am a data analyst working with a set of data on a spreadsheet and i would like some guidance on how to group it

Technician's Assistant: What's the brand/model/Operating System (OS) of your computer?

Lenovo/ Windows 7

Technician's Assistant: When did you purchase your Lenovo? What troubleshooting have you tried?

The computer has no problem, i need advice on using spreadsheets

Technician's Assistant: Anything else you want the Computer Expert to know before I connect you?

An expert in macros would really help

Submitted: 8 months ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Customer reply replied 8 months ago
Hallo analyst i am trying to regroup a set of data in excel ( sheet 1 of the file attached above) to take the form as appears in sheet 2 the data is volumous and i dont have the time to type it manually.
Kindly assist on preparing a macro to do the instructions as shown on the link in sheet 2.
Answered in 21 minutes by:
11/17/2017
Software technician: Jess M., Computer Support Specialist replied 8 months ago
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 775
Experience: Computer Software Support specialist for more that 10 years
Verified

What

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

I saw your raw data. Where is the collector ID and collection amount?

Please let me know by replying to me here so that I can help you further.

Best regards,
Jess

Ask Your Own Software Question
Customer reply replied 8 months ago
Jess why have i been charged before i have had an experience of your services
Software technician: Jess M., Computer Support Specialist replied 8 months ago

I am very sorry about the confusion. You were charged for the deposit, but all fees are refundable.

Ask Your Own Software Question
Customer reply replied 8 months ago
Question is the packages speaks of $5 dollars for the question which i am okay with paying but why should i pay $36 before i even i know if your services are worth while, that is wrong
Software technician: Jess M., Computer Support Specialist replied 8 months ago

I am very sorry about the confusion but I cannot answer that. From my end I can see that your question costs $39.6. I believe the $5 you mentioned was an initial deposit.

Please contact our customer service regarding issues on fees.

Here is the link about refunding if you do not want to continue:

ww2.justanswer.com/help/how-can-i-request-refund

Ask Your Own Software Question
Customer reply replied 8 months ago
I definately would want any part of this if i pay for a service i cannot access, kindly let as hold this discussion at this point for now . I will get back to you incase of anything more
Software technician: Jess M., Computer Support Specialist replied 8 months ago

Ok.

Ask Your Own Software Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a software technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 775
775 Satisfied Customers
Experience: Computer Software Support specialist for more that 10 years

Jess M. 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

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

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

Jess M.

Jess M.

Computer Support Specialist

775 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Chris L.

Support Specialist

526 satisfied customers

Certified Software expert with over 10 years experience.

Jins M. N.

Jins M. N.

Computer Hardware Engineer

517 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Kamil Anwar

Software Specialist

514 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

511 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Byron

Computer Support Specialist

187 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I use Access quite often and set up my own little databases
Hi, I use Access quite often and set up my own little databases - 5 of them. My computer did an update the other day and now all of my Macros are disabled. The database I am using has macro settings s… read more
Kennen McCarthy
Kennen McCarthy
President
CET Electronic Technician
25 satisfied customers
I need a spreadsheet that compares 2 data sets. Each data
I need a spreadsheet that compares 2 data sets. Each data set has 5 columns/variables. I need 2 of the columns to be cross referenced between the 2 lists and to show me missing ROWS in the data sets.… read more
Michael Rademacher
Michael Rademacher
MBA
13 satisfied customers
I am making some changes on an excel workbook. It is a
I am making some changes on an excel workbook. It is a workbook that contains an identical sheet for each month as well as two other sheets for yearly tallies. Is there some way to propagate changes t… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
630 satisfied customers
I need an excel formula that will combine data from
I need an excel formula that will combine data from different lines of a spreadsheet into a single line. I have a large excel spreadsheet about 200,000 lines of data. It contains delinquent real estat… read more
George Sibiya
George Sibiya
PhD
309 satisfied customers
In excel, I have a LOT of cells that are only showing me a
In excel, I have a LOT of cells that are only showing me a portion of contents of the cell. If I hit F2 on the cell, it then displays all of the contents.However, I can't do this for the thousands of … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,464 satisfied customers
Microsoft Excel Required:- an Excel "Expert" - a person with
Microsoft ExcelRequired:- an Excel "Expert" - a person with "advanced" Excels Skills and Practical Experience.Please do not apply unless you are certain that you understand the question and that you c… read more
Steve
Steve
Consultant
Bachelor
69 satisfied customers
Google sheets- See attached pic. I am trying to take the
Google sheets- See attached pic. I am trying to take the column headers from the top and place on the rows and have the corresponding data follow.(I am exporting google forms into sheets and I would l… read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
919 satisfied customers
Need assistance with an Index/Match problem, see attached.
Need assistance with an Index/Match problem, see attached. Lookup table is in bottom half of sheet. Need to return a Rate in C2 when user selects dropdowns in A2 and B2 from data in Columns Code1:Code… read more
Bruce Wilner
Bruce Wilner
Master of Engineering
30 satisfied customers
I need to know how I can give copies of a already written
I need to know how I can give copies of a already written Excel workbook with VBA code code to other people and ensure that those other people simply make a copy ofit and then distribute it themselves… read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
919 satisfied customers
My Excel 2013 has a mind of its own it seems it is always
Richard My Excel 2013 has a mind of its own it seems it is always something. My problem today is when I try to insert a new row in between rows that are already populated I get an error message which … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,464 satisfied customers
I had an excel spreadsheet created with the help of this web
I had an excel spreadsheet created with the help of this web site that has been very useful to me. However, I just started using office 2013 and notice that the macro in this spreadsheet no longer wor… read more
Jason Jones
Jason Jones
AAS Information Technology
6,327 satisfied customers
question with grouping data in excel. I have names in several
question with grouping data in excel. I have names in several columns and I want to get the ranking in the cell next to it. The numbers I want are in the column previous to it same row.… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
630 satisfied customers
We need an online form, to collect data (mainly names/dates/times/nume
We need an online form, to collect data (mainly names/dates/times/numerical data) for a small group of 5. There are many low-cost (or even free, for low-volume) versions, but not easy to choose. We do… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Im trying to combine two excel workbooks into one workbook.
I'm trying to combine two excel workbooks into one workbook. My problem is both workbooks have very complicated macros. If I provide the two workbooks can you combine them for me? Thanks… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
775 satisfied customers
I have tested the ease of creating a fillable form in Adobe
I have tested the ease of creating a fillable form in Adobe Professional. Very easy and now I'm wondering how I can take the data that is provided back to us from the form (via email or placed in a sh… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,464 satisfied customers
I would like to convert data from a PDF report I get weekly
I would like to convert data from a PDF report I get weekly automatically into a excel spreadsheet I have already created, but I only want to take out some data etc. Is there a way I can do this?… read more
WesPCDr
WesPCDr
Master\u0027s Degree
170 satisfied customers
Hello. I am trying to compare columns in excel in three different
Hello. I am trying to compare columns in excel in three different spreadsheets. I am comparing, trying to find names in each spreadsheet that exist in the other two spreadsheets. However, the names AR… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Microsoft excel VBA - Need to consolidate rows of data that
Microsoft excel VBA - Need to consolidate rows of data that have duplicate data in specific columns and combine the data in a third column. I have over 1 million rows of data. 1. Consolidate duplicate… 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