Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc