Question description:
This user has given permission to use the problem statement for this
blog.
I have multiple columns of data. I would like to be able to continuously add to these separate columns and have all the data points added to a separate sheet that sorts alphabetically and says what column the data point was under
Solved by X. B. in 31 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/07/2018 - 03:20
Greetings!
Excelchat Expert
03/07/2018 - 03:21
Thank you for choosing Got It Pro!
Excelchat Expert
03/07/2018 - 03:21
Seems like you need help with your data and formulas, is that right?
User
03/07/2018 - 03:21
Yes. Does my question make sense or should i put an example on the sheet?
Excelchat Expert
03/07/2018 - 03:22
Please do put an example, that would make things easier for us.
User
03/07/2018 - 03:23
So my first sheet looks something like this
User
03/07/2018 - 03:24
but with everything filled obviously
Excelchat Expert
03/07/2018 - 03:24
Sure, go on,.
User
03/07/2018 - 03:25
I'd like to make another sheet that lists all of these debtors listed alphabetically. And I'd also like for it to show what client they belong to
User
03/07/2018 - 03:25
But in a way that I can keep adding data points and it updates the alphabetical list
Excelchat Expert
03/07/2018 - 03:26
Alright, I think I'm getting it.
Excelchat Expert
03/07/2018 - 03:26
See the Alphabetical List sheet, is that how you want it to look like?
User
03/07/2018 - 03:26
Yes exactly
Excelchat Expert
03/07/2018 - 03:27
Alright, got it.
Excelchat Expert
03/07/2018 - 03:27
Question though, is it okay to modify the format of the Data sheet?
User
03/07/2018 - 03:27
Sure
Excelchat Expert
03/07/2018 - 03:27
Cool. Please give me a few minutes to provide you a solution for this one.
User
03/07/2018 - 03:28
Sure thing, thank you
Excelchat Expert
03/07/2018 - 03:36
Alright, so here.
Excelchat Expert
03/07/2018 - 03:38
So you would want your Data to follow the columns in the Data sheet.
Excelchat Expert
03/07/2018 - 03:39
You see, when we add new data to the Data sheet, it automatically updates the Alphabetical List 1
Excelchat Expert
03/07/2018 - 03:40
Does this answer your concern?
User
03/07/2018 - 03:41
Ah, okay. So which client the debtor belongs to would have to be put in column D?
Excelchat Expert
03/07/2018 - 03:41
Yes.
Excelchat Expert
03/07/2018 - 03:41
That way, you have an organized list and a table that automatically updates everything! :)
User
03/07/2018 - 03:42
Is there no way to make the client an overarching heading that encloses the "sub headings" of debtor, date, and price? Does this complicate it too much?
Excelchat Expert
03/07/2018 - 03:43
Yes, that would be right. Unfortunately the table that we have requires the list to be in that format for it to function properly.
User
03/07/2018 - 03:44
I understand. This is very helpful though, thank you! Could you explain how you made this table?
Excelchat Expert
03/07/2018 - 03:44
Alright!
Excelchat Expert
03/07/2018 - 03:44
Certainly, that table is called a Pivot Table.
Excelchat Expert
03/07/2018 - 03:45
First, you can download this workbook we have for your reference by going to File > Download As > Microsoft Excel
Excelchat Expert
03/07/2018 - 03:45
So pivot tables, you do them by selecting the columns of the data you would use as reference, then Data menu and then Pivot Table
Excelchat Expert
03/07/2018 - 03:46
In Excel, it would be select the Data, Insert and then Pivot Table
Excelchat Expert
03/07/2018 - 03:46
The Pivot table window would show up and you just have to add your column headers to be either Rows, Columns, Values or Filters. In this case, all of our columns should be Rows.
Excelchat Expert
03/07/2018 - 03:47
And there you go! :)
User
03/07/2018 - 03:49
What is the difference between rows and columns in the pivot table?
Excelchat Expert
03/07/2018 - 03:50
Mainly the presentation.
Excelchat Expert
03/07/2018 - 03:50
I'm afraid that per company policy, we're only allowed to answer one concern.
User
03/07/2018 - 03:50
Okay, I understand. Thank you very very much! This was incredibly helpful
Excelchat Expert
03/07/2018 - 03:51
I'm glad to have helped!
Excelchat Expert
03/07/2018 - 03:51
I have marked this as answered. Please leave a feedback after you end our chat session for us to know how we did today. Have a good day!
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.