Question description:
This user has given permission to use the problem statement for this
blog.
I need help with sorting in Excel. I created a sheet where we have listed names in the first column and then info pertaining to them in the columns to the right of that. The names aren't on each row as we have to have blank lines below the name because the info to the right of the name is long. so when we go to sort from a to z so that the names will be in order alphabetically, the info to the right of the names doesn't follow. Thanks so much we are desperate over here.
Solved by E. C. in 36 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/09/2018 - 02:18
Hi
Excelchat Expert
06/09/2018 - 02:18
Welcome to got it Pro
Excelchat Expert
06/09/2018 - 02:18
Please tell me more about the requirements so that i can help better
Excelchat Expert
06/09/2018 - 02:19
Do you have a data that you can share for me to look at
User
06/09/2018 - 02:19
Hi there! That was quick, thank you so much!
User
06/09/2018 - 02:20
my main problem tonight is going to be that I could not bring the file from work because it contains confidential data. I can try to recreate it with info like "mickey mouse"
User
06/09/2018 - 02:21
If I can recreate the file but with other names, would that work
Excelchat Expert
06/09/2018 - 02:21
Yes please tell me a bit more about your requirement
Excelchat Expert
06/09/2018 - 02:21
yes
User
06/09/2018 - 02:21
ok, the columns that we had are "Name, Date of Birth, Sex, Other"
User
06/09/2018 - 02:22
just a sec
Excelchat Expert
06/09/2018 - 02:22
I wrote theat on spreadsheet on right
User
06/09/2018 - 02:23
oh gosh! ok, i love this! Thank you. Let me get you some more details so you can help with our problem
User
06/09/2018 - 02:24
oh my, i just noticed this is timed. Can we pay for extra time?
Excelchat Expert
06/09/2018 - 02:24
may be you can extend the time
User
06/09/2018 - 02:24
how do i extend it?
Excelchat Expert
06/09/2018 - 02:24
but lets try to finish up in this time
User
06/09/2018 - 02:24
it says i have 13 min
Excelchat Expert
06/09/2018 - 02:24
you will get an option when times says 3 min left
User
06/09/2018 - 02:25
ok
User
06/09/2018 - 02:25
so do you see how you have the letters under the name column directly below one another?
User
06/09/2018 - 02:25
we have blank lines in between the names because of all the info that we have to put in other
Excelchat Expert
06/09/2018 - 02:25
Yes
User
06/09/2018 - 02:26
I wish that i could type the info in there for you to see what i mean
User
06/09/2018 - 02:26
i am so sorry we are just no good at this but have to get it because boss wants it in excel
Excelchat Expert
06/09/2018 - 02:27
can you show me how it is exactly
User
06/09/2018 - 02:27
when we enter the names they are alphabetical, and we want to use the sort op
User
06/09/2018 - 02:27
ok, will it let me type in there?
Excelchat Expert
06/09/2018 - 02:27
Something like this?
Excelchat Expert
06/09/2018 - 02:27
B and E are not in names so they are in other?
Excelchat Expert
06/09/2018 - 02:28
Do you see?
User
06/09/2018 - 02:28
i see but don't understand, will it let me type so you can see what we mean
Excelchat Expert
06/09/2018 - 02:28
Yes
Excelchat Expert
06/09/2018 - 02:28
Please go ahead and type on spreadsheet
User
06/09/2018 - 02:28
ok, can i start now
User
06/09/2018 - 02:28
ok
Excelchat Expert
06/09/2018 - 02:28
Sure
Excelchat Expert
06/09/2018 - 02:31
what exactly is required from this dataset?
User
06/09/2018 - 02:32
now we want to sort alpha name and when we do, the info in the "other " column doesn't follow the appropriate person
Excelchat Expert
06/09/2018 - 02:32
It will come like this
Excelchat Expert
06/09/2018 - 02:33
It is getting sorted
Excelchat Expert
06/09/2018 - 02:33
but the values in other column are not related to this
Excelchat Expert
06/09/2018 - 02:33
so they will be be shown like this
Excelchat Expert
06/09/2018 - 02:33
Do you get?
User
06/09/2018 - 02:34
ok, that is exactly what it does to us, but we want the information to follow the person
Excelchat Expert
06/09/2018 - 02:34
You can do one thing
Excelchat Expert
06/09/2018 - 02:35
See column for Name 2
Excelchat Expert
06/09/2018 - 02:35
i have added one more column
User
06/09/2018 - 02:36
i see that you added another column labeld name 2
Excelchat Expert
06/09/2018 - 02:36
You can paste the formulas and extend the formula down
Excelchat Expert
06/09/2018 - 02:36
then paste them as values and then sort the values
User
06/09/2018 - 02:37
i apologize, i do not understand
Excelchat Expert
06/09/2018 - 02:37
I added a column named Name2
Excelchat Expert
06/09/2018 - 02:37
where i have applied the formula
Excelchat Expert
06/09/2018 - 02:38
now you can apply them as values and then sort it
User
06/09/2018 - 02:38
ok, what is the formula? is it the name
Excelchat Expert
06/09/2018 - 02:38
by name 2
Excelchat Expert
06/09/2018 - 02:38
formula is in name 2 column
Excelchat Expert
06/09/2018 - 02:38
Double click on E2 and see the formula
Excelchat Expert
06/09/2018 - 02:38
=if(A2<>"",A2,E1)
Excelchat Expert
06/09/2018 - 02:39
Do you understand now?
Excelchat Expert
06/09/2018 - 02:39
now you can paste it as values and then sort the column
Excelchat Expert
06/09/2018 - 02:39
all the values will come together now
User
06/09/2018 - 02:39
i am so sorry, i do not because i was trying to watch
Excelchat Expert
06/09/2018 - 02:40
i have created another column named name2
Excelchat Expert
06/09/2018 - 02:40
in that i have applied the formula
Excelchat Expert
06/09/2018 - 02:40
if value in cell A is not null then take that name else take name from one value above in column E
Excelchat Expert
06/09/2018 - 02:40
=if(A2<>"",A2,E1)
Excelchat Expert
06/09/2018 - 02:41
paste the same values on column H to L without formula
Excelchat Expert
06/09/2018 - 02:41
and have sorted it
Excelchat Expert
06/09/2018 - 02:41
see
Excelchat Expert
06/09/2018 - 02:41
Do you understand now?
User
06/09/2018 - 02:41
i am trying hard to understand it
Excelchat Expert
06/09/2018 - 02:42
Try to go through it and see
User
06/09/2018 - 02:42
so if i make another column to right and put the formula you did it will work?
Excelchat Expert
06/09/2018 - 02:42
yes
User
06/09/2018 - 02:42
ok let me do that now
User
06/09/2018 - 02:42
you want me to look at it on this sheet
Excelchat Expert
06/09/2018 - 02:43
I am saying that i have provided the solution just try to see and understand it
Excelchat Expert
06/09/2018 - 02:43
have added a column to fill name names in blank cells using formula
User
06/09/2018 - 02:43
ok, i am looking now
Excelchat Expert
06/09/2018 - 02:44
and then sorted it so that blank name data gets sorted accurately
Excelchat Expert
06/09/2018 - 02:44
after making the column name2 sort on that column name2 only
User
06/09/2018 - 02:45
ok, so if we print out the sheet, is it going to print name 2 column?
Excelchat Expert
06/09/2018 - 02:47
Your question was to sort the values
Excelchat Expert
06/09/2018 - 02:47
for printing you can print anything on excel
User
06/09/2018 - 02:47
ok, thank you so much
Excelchat Expert
06/09/2018 - 02:47
Once you sort it by name 2 then for you purpose you can only keep first 4 columns
Excelchat Expert
06/09/2018 - 02:47
Do you understand
User
06/09/2018 - 02:48
i think i do. we are starting to have to do more in Excel, do you all have an option to pay for help, this way in the future we can pay and use you all?
User
06/09/2018 - 02:49
we are going to try to take class but there are some things that they are needing right now
Excelchat Expert
06/09/2018 - 02:49
Yes
User
06/09/2018 - 02:49
our company would pay
Excelchat Expert
06/09/2018 - 02:49
I understand
Excelchat Expert
06/09/2018 - 02:49
You can use Got it Service
Excelchat Expert
06/09/2018 - 02:49
lot of good experts are there
Excelchat Expert
06/09/2018 - 02:49
For your current problem, the solution i have provided will work in your case as of now
Excelchat Expert
06/09/2018 - 02:50
I hope you will give good rating and reviews when you end the session
User
06/09/2018 - 02:50
ok, yes, will do and again, thank you
User
06/09/2018 - 02:50
where do i rate?
Excelchat Expert
06/09/2018 - 02:51
When you press the end button on your screen
Excelchat Expert
06/09/2018 - 02:51
you will get an option to rate
User
06/09/2018 - 02:51
ok, do i do that right now?
Excelchat Expert
06/09/2018 - 02:51
Hope to get good rating and reviews from you
User
06/09/2018 - 02:51
what is your name?
Excelchat Expert
06/09/2018 - 02:51
Yes if i have helped you you can end the session
Excelchat Expert
06/09/2018 - 02:51
we are not allowed to share our personal details
Excelchat Expert
06/09/2018 - 02:52
it is against policy
Excelchat Expert
06/09/2018 - 02:52
hope you understand
User
06/09/2018 - 02:52
oh, i am sorry, i was just going to mention in rating or didn't know if i had to have that info
Excelchat Expert
06/09/2018 - 02:52
No problem
User
06/09/2018 - 02:52
i am going to try and apply your training to our spreadsheet we have going
Excelchat Expert
06/09/2018 - 02:52
Sure
Excelchat Expert
06/09/2018 - 02:53
You can end the session to provide your reviews and ratings
User
06/09/2018 - 02:53
can i ask one more thing
Excelchat Expert
06/09/2018 - 02:53
your reviews also help a lot
Excelchat Expert
06/09/2018 - 02:53
We generally have a policy of one question per session, hope you understand
User
06/09/2018 - 02:54
if we have a spreadsheet saved on a flash drive and we are paying for assistance, can we get our file to you so that you can see it
User
06/09/2018 - 02:54
oh ok, sorry
Excelchat Expert
06/09/2018 - 02:54
Yes you an upload on spreadsheet
Excelchat Expert
06/09/2018 - 02:54
that is what i said at the beginning of our session
User
06/09/2018 - 02:54
i just see an attachment option and was wondering . i am so sorry
Excelchat Expert
06/09/2018 - 02:54
File can be attached in chat option also
User
06/09/2018 - 02:54
ok, i will end the session now. thanks again
Excelchat Expert
06/09/2018 - 02:54
Welcome
Excelchat Expert
06/09/2018 - 02:54
Take Care
User
06/09/2018 - 02:55
same to you, bye
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.