Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I can not make a pivot table keeps saying I do not have colums
Solved by M. H. in 24 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/03/2018 - 09:48
Hi there
Excelchat Expert 24/03/2018 - 09:48
How are you and how amy i assist you with today?
Excelchat Expert 24/03/2018 - 09:50
are you there, Sir/maam
Excelchat Expert 24/03/2018 - 09:54
Can i get a reply?
Excelchat Expert 24/03/2018 - 09:57
let me know when you see my texts
User 24/03/2018 - 09:59
Hello I can not merge three excel files together
Excelchat Expert 24/03/2018 - 09:59
okay
User 24/03/2018 - 09:59
and I can not make a graph or pivto table
User 24/03/2018 - 10:00
pivoy
User 24/03/2018 - 10:00
pivot
Excelchat Expert 24/03/2018 - 10:00
so to do that you need to move the sheets to one excel file
User 24/03/2018 - 10:00
yes
Excelchat Expert 24/03/2018 - 10:01
okay to do that right click on the sheet name
Excelchat Expert 24/03/2018 - 10:01
and select copy
User 24/03/2018 - 10:02
I have it all in one now
User 24/03/2018 - 10:02
but I can not make a pivot tabe
User 24/03/2018 - 10:02
table because it says I need headers
Excelchat Expert 24/03/2018 - 10:02
yes all the columns should have an appropriate header, to make pivot
User 24/03/2018 - 10:03
how do I do that
Excelchat Expert 24/03/2018 - 10:03
just on top of every column write the column names
Excelchat Expert 24/03/2018 - 10:04
can you share me the sample work sheet
Excelchat Expert 24/03/2018 - 10:04
so that we both can have a better evaluation to the issue
Excelchat Expert 24/03/2018 - 10:07
and then bring all those columns in different sheets to on sheet
Excelchat Expert 24/03/2018 - 10:10
and then press Alt + N+V
User 24/03/2018 - 10:10
ok now I have it in a pivot table can you help me make a graph
Excelchat Expert 24/03/2018 - 10:11
Apologies, Sir/Maam we are restricted to one issue per session

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.