Hello Everyone,
I need your help please.
I have an excel file that list user ID and their specialties.
In their specialties can be from one to three types.
The list is downwards.
Meaning that the user can have 3 records to list all three specialties.
I need to find a way to list the specialties sideways.
I want just one record of user and list their specialties either from one to three types.
Example:
User - Specialty
4512 Cook
4512 clean
4512 Wash
to this one
User - specialty1 - specialty2 - specialty3
4512 Cook Clean wash
I have about 15000 records
Any info will be appreciated. thank you.
Full Version: Convert Down List To Side List
slcanas,
You are currently asking this same question here.
This is considered "Double Posting" and it is not allowed here at UA. It only creates confusion with the people that may try to help you.
Please stick with Bob-- you're in good hands!
You are currently asking this same question here.
This is considered "Double Posting" and it is not allowed here at UA. It only creates confusion with the people that may try to help you.
Please stick with Bob-- you're in good hands!
Hello,
Unfortunately, Bob was not able to help. However, when there is a long relay of responses in a topic, usually you don't get a response from a new person.
FOr this reason, that is why I created a new trend. Unless there is a way to repost the topic with black responses.
Would you be able to help me with this topic?
I would appreciate if you do.
Let me know.
Unfortunately, Bob was not able to help. However, when there is a long relay of responses in a topic, usually you don't get a response from a new person.
FOr this reason, that is why I created a new trend. Unless there is a way to repost the topic with black responses.
Would you be able to help me with this topic?
I would appreciate if you do.
Let me know.
Hi, From the timing of the posts in the previous thread and this one, it might appear that you could exercise a bit more patience in waiting for someone to come along and offer to assist.
Perhaps it's not clear, but the members who address questions are all volunteers. If someone sees a question and thinks they can help, they will almost always try to so do. However, if the question doesn't appear to be one that a reader can answer, they're likely to pass on by. Note that your question is about Microsoft Excel, which is NOT the primary focus of the UA forums.
Therefore, it is likely fewer folks will stop by to look. Moreover, the requirement you have laid out is not a "mainstream" Excel function, so it's probably something that will require quite a bit of unique coding.
This statement, though, puzzles me: "Unless there is a way to repost the topic with black responses."
What would that be?
In short, patience is the key and you'll probably get an answer at some point. And keep working with Bob, if you don't mind. He's a dedicated person who'll either figure out an answer or call for help.
Continued success with your project
Perhaps it's not clear, but the members who address questions are all volunteers. If someone sees a question and thinks they can help, they will almost always try to so do. However, if the question doesn't appear to be one that a reader can answer, they're likely to pass on by. Note that your question is about Microsoft Excel, which is NOT the primary focus of the UA forums.
Therefore, it is likely fewer folks will stop by to look. Moreover, the requirement you have laid out is not a "mainstream" Excel function, so it's probably something that will require quite a bit of unique coding.
This statement, though, puzzles me: "Unless there is a way to repost the topic with black responses."
What would that be?
In short, patience is the key and you'll probably get an answer at some point. And keep working with Bob, if you don't mind. He's a dedicated person who'll either figure out an answer or call for help.
Continued success with your project
Yes George,
I understand that this site is a volunteer based website. I did put my part in the past before.
I did not expect to get an answer quick as I understand that this is a complicated topic.
in my previous response, I meant to say Blank instead of black like Blank-out.
Im planning to move on to convert the file into access and see if there is a code I can use as SQL or query statement.
Thanks.
I understand that this site is a volunteer based website. I did put my part in the past before.
I did not expect to get an answer quick as I understand that this is a complicated topic.
in my previous response, I meant to say Blank instead of black like Blank-out.
Im planning to move on to convert the file into access and see if there is a code I can use as SQL or query statement.
Thanks.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.