Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office
This answer was rated:

I have data that runs horizontally but I need all of it to

be formatted vertically Therefore one...
I have data that runs horizontally but I need all of it to be formatted vertically

Therefore one line of horizontal information contains multiple data points that need to be listed individually vertically. 1 horizontal line could equal 30 or 40 vertical lines
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 2 minutes by:
8/7/2012
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified

Hi,

 

Would you be able to send me the file so I can take a look at the data. To do so go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.

 

If the file has sensitive information let me know before you upload it

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
ok
Customer reply replied 5 years ago
ok I uploaded the file You will see a "As is" current state of file and the future state is what I want it to look like

Where is the File ID or download link

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
File 931314

Got it, thanks

 

One moment while I take a look...

 

 

Ask Your Own Microsoft Office Question

Ok this cannot be done with formulas, functions or pivot table. A macro must be written to generate the list in that format. It will however take some time to set up the macro. Let me know

 

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

Ok Can you set up a macro. This is only a piece of one file for example only. The file has dates that from 1/1 - 6/30


 


 

In that case I need the actual file so we don't have to setup the macro twice
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Ok where do I submit it It is large 4 tabs and a total of about 10,000 lines combined in the 4 tabs each tab is a location

Upload it at this same site that I gave you

 

 

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
File # XXXXX Please note that when you look at these files and page down you will come across another row of Column headings Each of these breaks in the file start a new 2 week period. You will see the Week ending at the top of the column headings. thanks

That is a lot more complex than the sample sheet you sent me. Also do you want to generate vertical list for one sheet or all sheets

 

Accordingly I have sent a price adjustment report. Please confirm if the price looks ok to you and let me know so I can start working on this

 

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
vertical for all the sheets/tabs

If you agree to the suggested price adjustment please confirm so I can start working on it

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
where is this report?

JA should have sent it to you by email

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

I have not received anything via email


 

hmm..There must be an issue with the site

 

Ok experts are not allowed to suggest a prices in this forum (only through a special price report via JustAnswer). But customer can make an offer and the expert can either take it or not. So you can make an offer and I will let you know

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
I am unsure of price. I will wait for the price report.

No problem, but there are some reported issues where the system fails to send some emails

 

 

Ask Your Own Microsoft Office Question

In the meantime I finished the major part of the macro. Here is a screenshot of part of the output sheet for the first block of data on sheet 'Greenville'

 

 

Please check the above output and let me know is this is what you're trying to accomplish

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
That looks good!
Customer reply replied 5 years ago
Can I get a copy of the Greenville tab when completed so I can compare to my file and reconcile to ensure all the Units are captured then we can proceed with the other tabs.......Thanks

Ok will send you the result the Greenville tab

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Great Thank you

Here is the Greensville output for the for the first block of data on Greensville (rows 4 thru 65)

 

 

Attachment: 2012-08-08_141955_greensville_output.xlsx

 

Please check it and let me know

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

IT LOOKS GOOD AFTER A QUICK REVIEW


 


 

Great

 

I will send the file with the macro for that sheet which should work on any sheet with identical data structure (same columns and starting in the same row). Meanwhile you can rate the answer. Then when you get the file you can add the difference between the suggested price and the current question price as using the Add Bonus button

 

Thank you

 

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
John D and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Customer reply replied 5 years ago
Sounds Great

Thanks. (but the bonus is not the correct balance amount)

 

Here is the file with the code.

 

http://www.filesharesite.com/files/201208/1344438132South_Carolina_-_Copy_2.xlsm

 

To run the macro click the Go! button on the Greensville main sheet. It will process all data from row 4 until it hits a title row with the phrase "Sort Options:" in column A. To make it work for all data on that sheet you need to remove all intermediate headers and type "Sort Options" in the last row so the macro can know where to stop

 

Please note that since there is a macro in the file you need to make sure that you have your Excel Options configured so that macros are allowed to run, otherwise nothing happens when you click the button. If you need assistance in this regard please let me know,.and provide the version of Excel you are running

 

 

 

Ask Your Own Microsoft Office Question

Please use this file instead

 

http://www.filesharesite.com/files/201208/1344440432South_Carolina_-_Copy_2a.xlsm

 

It takes care of Ref numbers so they are not increased by 1 within the same client name

 

 

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Thank You. The Macro works well. The only question I have is when I ran the Macro for the next period in June it seemed like it is driven off of a range of cell A4-A65. Some of the periods and locations could have less then 62 rows while others could have in the 100's.

Did you notice my comment about the phrase "Sort Options:" which was posted with the message where I sent you the first file.

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Also, 1 more thing...how do I copy the Macro over to the other tabs???

If you are not familiar with macros I can install a button for you on each sheet, but as I said before the data structure of all sheets should be identical to the first sheet for which the macro was written

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago

Yes please install on all sheets for me. The structure should be identical


 


Thanks

Ok I will do that. But as I mentioned before the bonus you paid falls quite short of what was suggested for the question. So how do you intend to correct that

 

Thanks

 

Ask Your Own Microsoft Office Question

Ok I have set up buttons on all the sheets so will be able to run the macro for each sheet. However as I mentioned before the sheets have to 100% identical with the first sheet for which the macro was created in order that the macro can produce the correct results

 

http://www.filesharesite.com/files/201208/1344462211South_Carolina_-_Copy_2a1.xlsm

 

Hope this helps

 

 

Ask Your Own Microsoft Office Question
Ask John D Your Own Question
John D
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Bachelor of Science - Engineering Consultant

John D 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:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I can't recover a really important document that I was
I can't recover a really important document that I was working on … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I'm having trouble with creating an automatic table of
I'm having trouble with creating an automatic table of contents in Word. I think it has something to do with formatting in the document. … read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
There was an update today and since I did it I can't open
There was an update today and since I did it I can't open Word. There was one for PowerPoint and Excel and they are all fine … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
When I type an e mail to a particular person, how do I
When I type an e mail to a particular person, how do I include multiple names recipients . … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
I have a document on one drive that wont open because the
I have a document on one drive that wont open because the file is corrupted. How can I open the document. It represents a weeks work. Would it help to use a different computer? … read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
I have two cars a Hummer & Maserati I was able to access the
I have two cars a Hummer & Maserati I was able to access the Hummer, now I would like to use it on the Marz how do I do it? … read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
I just downloaded outlook 2016 but cannot open it. I get the
I just downloaded outlook 2016 but cannot open it. I get the following message: "Cannot start Microsoft Outlook. Cannot open the outlook window. The set of folders cannot be opened. The outlook data f… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
My laptop crashed with the last Windows 10 update. I had to
My laptop crashed with the last Windows 10 update. I had to buy a new laptop, but I need to recover my Microsoft 365 account. My contact information was on my old laptop. How do I recover my files? I … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,275 satisfied customers
My spreadsheet appears to be locked. It won' T let me input
My spreadsheet appears to be locked. It won' JA: What application are you using? Customer: t let me input numbers or alph JA: Have you installed any updates recently? Customer: Excel, no JA: Anything … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
We have Microsoft Word on our old computer under Wayne and
We have Microsoft Word on our old computer under Wayne and Beth Raasch Product ID 03***-***-****774-02692. When we tried to load it onto our new computer it asks for a 25 number long ID. This is all w… read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
My email account has suddenly started asking me for a
My email account has suddenly started asking me for a password ***** when I key in what I know to be the correct passwords … read more
Moses C
Moses C
Bsc
332 satisfied customers
I have a word file of 542 mb. Word won't open it reason it's
Hello there. I have a word file of 542 mb. Word won't open it reason it's larger than 32 mb in size. (However it will open a 330.4 mb file, both of which contain images and text). … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
I bought Word in 2013 for a lifetime, and a few weeks ago it
I bought Word in 2013 for a lifetime, and a few weeks ago it quit working. It won't open. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
New HP PC. Tried to share a file (failed). Unable to close
New HP PC. Tried to share a file (failed). Unable to close Word. Was using Yahoo mail. Just set up Outlook. Still unable to close Word. Get error about new message. Not sure what to do. … read more
Cris
Cris
58 satisfied customers
I just updated my Office package today, & now I'm missing
I just updated my Office package today, & now I'm missing the Frutiger font I purchased. It shows up in FontBook but not in the MS Word list. Most of my documents have a substituted font. How do I get… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR MY MICROSOFT OFFICE … read more
Moses C
Moses C
Bsc
332 satisfied customers
Is there a way to recover a document accidentally deleted
Is there a way to recover a document accidentally deleted from recycle bin? … read more
Chris L.
Chris L.
Support Specialist
Vocational, Technical or Trade Scho
147 satisfied customers
I recently re-subscribed to Office 365 as support for One
I recently re-subscribed to Office 365 as support for One Drive on my iPad so that I can use either the iPad or my Mac Book Pro for work. My problem is I can't find all the editing tools I need to typ… read more
bbao
bbao
Freelance IT Consultant
74 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