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.