Create a Pivot Table from multiple worksheets of a workbook
HTML-код
- Опубликовано: 21 авг 2024
- In this video, I'd like to share the technique to "Create a Pivot Table from multiple worksheets of the same workbook".
I have blogged about this problem at this link on my website - www.ashishmathu...
This is excellent I was searching something like this for more than a month, then landed here... Please post more videos like this which would be helpful on day to day basis in excel.
You are welcome. Thank you for the feedback.
Thank you so much! I spent hours looking for an answer and in nine short minutes, you were able to teach me how to do what I needed to do.
You are welcome.
Dear Ashish, I was searching the youtube for any possible solutions to combine multiple worksheets which contains same number of columns and infinite rows. In one of the videos, I could see that I need to have an unique cell for me to combine. Unfortunately I could not create an unique cell, but was on the look out, then your video was in hand. That was wonderful Ashish. I could quickly learn the MS SQL Query method and worked well for me. Thank you and I appreciate your efforts in educating.
+Ganesh Manchi You are most welcome. Sorry for the delay in replying.
Woo you are Amazing . I work with large quantity of data and this tutorial just made my life so easy. Thank you so much for sharing.
You are welcome. Thank you for your kind words.
No add no bakwas direct straight to the point...awsm...
Thank you.
hi Ashish, very good explanation so that everyone can understand the content easily..i have been looking for this content frm a time being..finally i got it thru your tutorial..thank you for this and keep uploading differnt contents..
Thank you for your kind words. I am glad you liked the content.
Thank you Mr. Mathur , This was worthwhile
You are welcome. I am glad you liked the solution.
mate you are an absolute hero!
Tom Roberts Thank you for your kind words.
Brilliant video! This is incredibly useful.
You are welcome.
Awesome tutorial Ashish.. Thanks for teaching this technique in such a short time.... Regards and keep doing the good work......
Manpreet Singh You are welcome.
this is like an alternative to using power pivot for appending data, nice!
Thank you.
very good and straight to the point. I like it. Thank you.
You are welcome.
Great content! Thank you for posting this solution, great example of the power of Pivot tables and MS Excel Query!
You are welcome.
Thanks for the great Video. This is exactly what I was looking for today..you saved my day. I would like to understand whats the purpose of creating Dummys as well as table-names? and how are they related?
You are welcome. When you create a Table, excel assign it a name automatically. Converting the range to a Table is necessary because this takes care of auto expansion. Table names cannot be used in MS Query and that is why we assigned a name called Dummy. Hope this clarifies.
Superb.. Nice explanation, very much useful topic. Thank you for sharing.
Thank you for your kind words.
Thank you very much. learned a lot from your video.Thank Internet & youtube
+Sugeeth Bimsara You are welcome.
Thank you very much. This is a superb video
You are welcome.
Thank you for posting this! This has helped me so very much.
You are welcome. Glad to hear that.
Thank you so much Sir! That was awesome! Please keep educating us!
You are welcome. Thank you for your kind words.
Thank you for posting, very helpful.
Quick question: could this technique be used to combine several pivot tables?
You are welcome. No.
You are my lifesaver. THANKYOU
You are welcome.
thank you for posting this tutorial....great job Sir!!
+Rogel Noble You are welcome.
Excellent video and to the point ! 👌
Thank you.
thank you so much for such very useful tutorial, great job
Thank you.
Thank you so much Ashish.. It's very useful..
You are welcome. Thank you for the feedback.
Hi Ashish, by far the best video on this topic - hands down!!!
May I bounce off a idea/question to you?
I have 4 files with the same table structure of data. I (1.) created an named range and then (2.) a table of the name range.
Using your method, I "queried" the 4 files/4 tables on 4 sheets in a new workbook in order to combine the 4 sheets on one (new) sheet.
I now have the issue that I have 4 tables (2.) created before I created 4 named ranges (1.).
(On creating the MS Query link the resulting table is MS table name Table_Query_from_Excel_Files)
When I now combine the 4 tables into 1, MS Query cannot find tables in the this workbook. Is there something to the order of executing Step 1. and 2. in this order?
I went and took the 4 system tables pointing at each sheet (paying attention to the '$' at the end of each system named element)
Could I have gone straight from 4 files to one table w/o the intermittent step of 4 tables in one workbook?
Thanks a lot in advance.
Cheers
Dirk
Thank you. Please follow the steps outlined in the Blog article here - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
You're awesome Ashish!! Great job
Thank you for your kind words.
thanks so much ...you make my project complete...
You are welcome.
Thank you very much Ashish !!
You are welcome.
Great!! you helped me a lot!! thanks
You are welcome.
Thanks very much Ashish, great video! It's a bit tricky way, but I couldn't really find an easier one. Is there a way to put it all as VBA?
You are welcome. Yes, one can write VBA code to append data from multiple worksheets into one and then create a Pivot Table.
thank you for your immediate response
You are welcome.
Hi Ashish, Do all the worksheets need to have the same number of columns? Will this work for different number of columns?
Hi. No, it wont. Please refer to all steps at this link - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
awesome voice and well done explanation
+Natesh Iyer Thank you for your kind words.
Great!!! It helps me a lot.
+Yee Sheen Chua You are welcome.
what if we want to link a particular cell range(IN VERTICAL) of 150+ sheets in to one master sheet HORIZONTALLY??? EXAMPLE APRIL 2016 TO MARCH 2017 WORKING DATA OF 150 EMPLOYS IS AVAILABLE IN THEIR RESPECTIVE 150 SHEETS VERTICALLY AND WE WANT TO EXTRACT THEM TO ONE MASTER SHEET IN APR TO MAR FORMAT BUT HORIZONTALLY ????
Very helpful! Thank you for uploading. May I ask what was the point of naming the ranges prior to creating the tables? Could you just rename the tables from Table1, Table2, and Table3 instead and pull from that? Or does Microsoft Query not pick up on Table names?
Nathan Ondricek Thank you. Neither can one rename the default Table Names nor can one use them in MS Query.
Wow.. I can make a Pivot Table out of data now. Thank you for making this video.
Initially, I had faced problem creating PivotTable because one of my worksheet name is "DB2", which is a cell number.
First, table name was not appearing on available tables. So, I had to select "System Table" from Query Wizard option and picked "DB2$" as table name. And, during union I had to double quote the table name else it gives syntax error.
You are welcome.
Thank you for sharing this great work. I have 3 worksheets and I wanted to create a pivot tab which consolidate the data from the 3 worksheets. I followed all the steps as described in your video, and everthing went well. except at the end when I created the pivot tab. In fact it won't sum the values; instead it's giving me zero values...despite having numbers in all worksheets. Would appreciate if you can help me out with this one. THanks
You are welcome. Thank you for your kind words. Ensure that the first cell of every column which you have dragged to the value area section of the Pivot Table has a number in each source data worksheet. Then click on Refresh. If this still does not work, then share the link from where I can download your workbook.
Hi, Thank you for your reply. All my data source sheets have numbers, but still not working.
In the same time I have noticed something strange, actually when I double click on the pivot tab total for the data to get the details, in the column that has the numbers...the format of the numbers is coming as Standard/ General format and even if I change it to numbers it's not being actually converted, and when I select multiple cells excel is just counting the number of items and doesn't sum the values. So I guess there is a formatting issue here. but I'm sure my numbers in the data source are stored as numbers.
How can I share my workbook privately with you? Thanks
I just realized one more thing after I double clicked on the pivot tab total, in the details the numbers of one the worksheets are somehow converted to date and time figures!!! not sure why?
Hi Ashish, never mind, I cleared off all the previous formatting of the entire data source and then reworked it. and repeated the same steps and it's working just fine now. Thank you for your help. Have a great day.
Good to hear that the problem is now resolved.
Thank you, thank you, thank you.
John Fite You are welcome.
+Ashish Mathur
Ashish.
Your video Create a Pivot Table from multiple worksheets of a workbook was great. One question, if I add another worksheet, and create new tables, how do I add that to the MS Query and then to the pivot table output.
Thanjks
+Shick Yingel You are welcome. Please refer to the method (www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/) outlined under this heading "Update Table/Pivot Table for addition of new worksheets"
Thanks for sharing the video. I have around 10 sheets.. and there is an error saying microsoft query has stopped working when adding the table. Please note, i have used system table. Please let me know if do the table mapping as mentioned in the video, will error go off?
Hi. Please read the steps here - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Thanks a bunch! Just what I needed :)
You are welcome.
Nice information. Just a thought. Can't we change SQL statement via testing IsNull function to replace null values with zero. That will eliminate problem of adding superficial 0 we added in the spreadsheet.
Thank you. I do not know how to use the SQL programming language. Someone who does can try to use the IsNull.
Thank you sir! This is very helpful for my work. :)
+Shab Chique You are welcome.
Hi Ashish. Do all the worksheets need to be in the same workbook?
Hi. Yes. Please read all steps in this article - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Hi Anshish,
Thanks for this video. It will really be great if this works for my data. I followed all the steps till the SQL statements. I get the message that "The number of columns in the two selected tables or queries of a union query do not match".
I have 91 columns and between 200 and 5000 rows in each table (5 of them) and they are all created from the same shell. I have even copied and re-pasted the column names from the first table to all the others and manually checked them but I still get the same error. Are my columns too much or what could be the problem?
You are welcome. I cannot say. If you are absolutely sure that the number of columns in both datasets is the same, then it looks like there is a "number of columns" limitation. The best approach would be to use Data > Get & Transform to aggregate data from multiple worksheets into a single one.
Thanks sir good job
It was too helpful
Thank you.
This is amazing and easy, however if I have two tables in same sheet and in multiple worksheets, how will I import data???
Appreciate you reply. Thank you!
+Abu Rayan Thank you. The tables could be anywhere on the workbook. Al Tables could be on the same worksheet or in different worksheets. As you can see in the video, the tables are being recognized by their assigned names (not by their worksheet location).
Thank you for this helpful tutorial. Can a pivot table be created from multiple sheets each with different column names, the majority with dates and some with phone numbers?
You are welcome. No. The column names should be the same.
Ok, thank you.
You are welcome.
Thanks a ton! It works.
You are welcome.
Great video! I had success in creating the pivot table but had issues when I renamed the file. Is there a way to remove old queries and create new ones within the same file?
+Bridget F Hi. You may refer to my solution at this link (www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/). Go to the section at the bottom (Update Table/Pivot Table when files are mailed to someone else) and apply the steps mentioned there.
GOOD IT HELPED ME A LOT THANKS...
+Sagar nara You are welcome.
Hi Ashish, may I know why the numbers cannot be captured when I refresh with a different columns? I need to redo the query to make it right. am I missing something in thr individual tabs?
+Jean Neo Hi. I do not understand your question.
Thank you for sharing this information
I used this information and created a pivot table using multiple sheet, but I was not able to use the time line feature of pivot table. May you please help me. How can I use time line feature , if I will create pivot table using this multiple sheet .
I do not know. May be the timeline feature is not available on Pivot Tables created via this method.
Hi Ashish, Great Content! I tried to create my pivot table using more than 5 spreadsheets, but after I clicked "ok" in the final step of returning data to excel, it said "ODBC error" then "problems obtaining data" , any idea what's going on? Is there any limit of the number of spreadsheet we can use at one time?
Thank you. No, as far as I now there are no limits on the number of worksheets. Read the steps here and retry - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
HI Ashish -
I tried to point my data source to excel. The options in the query will have the excel option but the pull down menu when it shows for the file name only shows "Data Sources" and does not see any excel int he list. What am I doing wrong here?
Thanks,
Hi,
I do not understand. Please explain again.
Very informative video, do you know any way to implement the same technique in smartsheet ?
Thank you. No, i do not know how to do it in Smartsheet
I am running with an issue, I have two work sheets and I created tables for both separately but when I go to query wizard there it shows table of second sheet only.
Can you please suggest why this is happening?
I suggest that you solve this problem using Power Query and PowerPivot.
Hi Mr Mathur, thank you for this video. I have similar data as you over 4 worksheets and would like to merge into one. I am stuck at step 1 as I realize I am simply unable to name my range cells as 'dummy'. I'm using excel 2016, is this causing the issue?
Sir, I managed to get hold of Excel 2007, and your technique works perfectly in Excel 2007
Hi. You are welcome. Please refer to the steps outlined here - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Good to know that. Thank you.
super information thanks a lot I really loved it.
You are welcome. Thank you for the feedback.
I am needing to write the formula in my reconciliation tab from the July tab. I keep getting an error. I have my monthly bills on each tab and then need the balances for the reconciliation tab. Do I need to find another tutorial for this?
Your question does not seem to be related to my video at all. Post your question in some MS Excel forum.
Thanks Ashish its really helpful :)
+Vipin Singh Thank you.
Hi Ashish,
It was very useful. Thank you so much.
Also I am working on more than 1 lakh records. Could you please help me to get any video for that ?
You are welcome. This technique should work for 1 lakh records as well.
Hi Ashish,
Thanks for the reply. It is not working for me more than 65K in single sheet. wanted to create a table for more than 1 lakh records.
Hi. This technique will work only for upto 65,000 rows of data per worksheet. You may split the rows into 2 worksheets and then it will work fine. An even better option is to use the BI tools of Excel, namely PowerPivot and Data > Get & Transform.
Hi Ashish I m facing problem at the end where it says could not add the table 'dummy', please suggest.
Hi. Please follow the steps outlined here - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Hi, I have tried this trick successfully in the past. Recently, I tried using it on a file with 21 data tabs. I got the message "The query wizard can not continue because it can not join the tables in your query. You must join the tables manually in Microsoft query by dragging the fields to join between the tables". and also "too many fields defined" Do you know what I'm doing wrong?
No. I need to see your workbook.
Hi thanks for sharing the video
Just One question How to make weekly report in Pivot table?
Thanks
Please elaborate.
Syed Ahmed v
Hi Ashish,
Just a query, under pivots i can group a field to Months and week as well (days and set the index to 7) but if i require to group the data based on weeknum,how could i do it (like Wk 41). Using days in group will show the date range as 1/1/1990 to 8/1/1990 but i want to show Weeknumber.
Need to do that in Pivot only else i could have done adding 1 extra column in data and putting there the weennum formula but if i have the huge data spanning across differnt sheets, adding a column is big pain and time consuming as well. Any suggestions. Please mail me if question is not clear
+Vikas Goel Hi. You will have to create a separate column to extract the week number in your base data sheet and then drag that column to your Pivot Table.
and i have a one query, suppose there are more than 20 sheets in the workbook, then do we need to follow the union all process (copy n pasting "select * from abc") for 20 times? or do you have any simplified query that can be union all the sheet? please assist.
Yes, if there are 20 named ranges, then there will be 19 Union all statements.
+Ashish Mathur - Thank you for the reply. Dont we have any short query like union all sheets?
Hi. Even if there is, I do not know that technique.
can we do the same if top row(labels) in one worksheet doesn't match with the other worksheets. 2. if voucher # is in 3rd column of the worksheet 1 and Voucher # is in 10th column of worksheet 2.is this still applicable
+saima qaiser No. There has to be structural similarity across all worksheets.
I really liked this video. Helped out a lot.
But unfortunately, I get an error when I type the SQL statement. The error is saying: " Incorrect column expression: '*' ".
Could you please help me out?
I'll need to see your query. Also, follow the steps outlined here - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Thank for the great video on pivot table, however sum functionality is not working, upon selecting sum its just showing 0 but number are showing the accurate number.
Hi. Refer to the steps at this link - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
May I know if there is table row limitation for MS query? I opened From MS query but don't see the table (76490 rows in the excel file) that I've created?
Hi. I think the number of rows per Table in MS Query is 65,000. Break that table into 2 tables and see if it works. A much better technique would be to use Power Query and PowerPivot.
Hi Ashish, I get error "no visible tables", however while i do CTRL F3 i saw list of 3 ranges and tables as well
+Vikas Goel got the solution now, my mistake..i was ctrl shift arrow keys to select the data , it should have been Ctrl A.Nice tutorial ..thanks
+Vikas Goel You are welcome.
Ashish I have assigned names to range, converted them to table , opened a new sheet saved everything , selected From other source and choose from Microsoft query, choose excel files , choose the xls I have saved post this I get an error stating unrecognised database format followed by the path where I have saved my excel. please suggest
Hi,I do not know why that is happening. From similar comments posted by other users in the Comments of RUclips and my webpage, I understand that this problem happens when one "first converts to a table and then assigns a name". It should actually be to "first assign a name and then convert to a table". I cannot think of any other reason why this is happening.
Hi Ashish, i have select 2 source tables with blank rows (in future I may add data into that)..now the pivot table which i created using ms query also has blank rows..because of this my pivot charts also has extra blanks..how can I eliminate this
Hi. Do not have blank cells in your data source initially. Since you have converted the source dataset into a Table, the rows will expand automatically as and when you add further rows.
Hi Ashish, I'm getting zero values even though there doesn't seem to be any blank cells. The data set is very large though and it's difficult to check if indeed there are empty cells but when I select the column, it does give me a sum. Can you please help?
Ensure that the first cell of every numeric column of all sheets has a value of 0. Then Refresh the Pivot Table.
Hi, it seems to be working now. Thanks. Another thing though, my file has 15 sheets and only the first 4 sheets are being picked up in as available in the section where we choose columns. Any advice here?
I cannot help unless you share the workbook.
Hi, great with 6 sheets. Not working with 7. ([Microsoft][Ovladač ODBC pro Excel] Vnitřní chyba automatizace OLE. in Czech, something like [Microsoft][Controle ODBC for Excel] Inner error of OLE automatization.) Is there a limit for number of sheets? Thanks a lot. Zdenek
Hi. I have tried it for upto 5 worksheets and it works fine. I would not be surprised if there is some internal limit in MS Query.
what do i do if i get and error message saying 'too few parameters. expected 34' while creating the query?
Please ensure that you follow all steps outlined here - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Can you easily add additional worksheets to the existing query?
Hi. Follow the steps outlined in my Blog article - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Hi,
Thanks for the video ,
I got the error after Microsoft query "THIS data Source contains no Visible tables" as not able to mapped multiple worksheet, can u suggest
Hi. Please follow the steps mentioned here - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/.
This is an amazing tutorial.
Thanks
I am having a little problem. I am not being able to add more than 6 sheet. if i do so then I cannot the query sheet shows 6 box for the 6 sheet(for me they are months). but it doesnt show any data from the sheet.
Please advise.
+Arif Uddin Thank you. I need to see your workbook. Upload your workbook to OneDrive and share the download link here.
+Ashish Mathur onedrive.live.com/redir?resid=B3DC16B8C34242B6!179&authkey=!AF0vLBObejdSTtY&ithint=file%2cxlsx
also I tried this...
i have added all the tables for 12 months (without $ sign table). clicked next but it doesnt go to the next level. I click cancelled. but it shows me the boxes of 12 month with all the field name and the * at the top. i clicked the SQL icon and applied the union all formula with the 12 tables name.
double clicked all the * from all 12 table. it populated the data in the query.
and then click file and return to table.
and then I got he following message
[Microsoft][ODBC Excel driver] Internal OLE Automation error.
please advise.
Kind regards,
Arif
+Arif Uddin I face the same problem when adding all 12 tables - it does not go to the next level. I do not know why this is happening. I try later and let you know if I come up with a valid reason.
+Ashish Mathur thanks. I will wait for your reply. Appreciate a lot for your reply. Regards
Arif
Hi Ashish,
Again I would like to say thank for teach me something amazing.
Do you think there could be any solution for this? Please advise.
Regards
Arif
Hi, my work book is not allowing me to add insert as table.. why is that( what can be the reason)
Please follow the instructions at the following link - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Hi Ashish, thanks for your video. If I have millions rows data in two sheets, can I do this pivot. Is there any restriction in rows criteria in sql query part while append
Hi. If your data is that much, then it will be much better to use Power Query and PowerPivot.
@@excelenthusiasts thank you for your reply, can I have any tutorial about power query or power pivot for the table having same column names
@@vvvenkatbe Hi. See this video - ruclips.net/video/yL11ugShdrk/видео.html
Hello Sir, when i change the values from count to Sum im getting zero as result, there is no blank cells in the value columns please suggest
Hi. I cannot say why that is happening unless I see the workbook. Upload your workbook to OneDrive and share the download link here.
Hi Ashish,
Thanks for this, i have a huge data of nearly 13 lakhs lines split in to 2 sheets (Excel 2010) named the range as "half1" and "half2", trying to do the same as shown in the video, while trying get the data from other excel the range name is not appearing but coming as "sheet1$" and "Sheet2$", i am able to see the data getting imported, when i try to add them in to one using "union all" function i am getting an error saying could not add "half1".
My question is is there any limit for the range since i have taken nearly 7.5 lakhs lines per sheet, to cross check i have tried with very small numbers in each sheet about 10k lines, the Pivot worked.
Could you please suggest any other way to draw a pivot for the huge data (YTD I will be getting nearly 15 lakhs lines).
Thanks in advance
Ramesh
Hi,
Using Microsoft Query, you will not be able to breach 65,000 rows of data per worksheet because Named ranges can only for upto 65,000 rows. The solution would be to use Microsoft Query.
Hi, Thanks for uploading this video, but i have one query when i tried to so many around 100 of column it doesn't work, stated "to many query's", can you pls. help with some other technique. OR i have three files with same header and i want to in one pivot.
Hi. I suggest you use Power Query and PowerPivot to build a Pivot Table from such a large dataset.
Ashish when I choose my excel so that I can extract value for creating pivot table . I get an error stating unrecognized database format followed by the path where my files is save. Could you please let me know why do I see this error?
I am not sure why that error is popping up. Please ensure that you first assign a name to the range and then convert it to a Table.
One question, what to do if total columns in worksheets are different ???? Right now it's not working with this method please suggest
I do not understand. Please clarify.
@@excelenthusiasts will it work if we have 8 columns in sheet 1 and 10 columns in sheet 2 ?
@@minote282 I suggest that you solve this problem using Power Query and PowerPivot.
I get "Unrecognized Database" opening file into query. Could I have a setting off?
+Devang Desai Hi. Please refer to the steps mentioned at this link - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Hi, great tips, however i get an error message "ODBC excel Driver. Internal OLE automation error" :(
Hi. Looks like some installation error. Sorry but cannot help here.
Awsm...
Thank you.
Is there a limit on the amount of data sheets that you can connect? Thank you.
No. I do not think so.
Ashish Mathur Thank you for your feedback.
Thanks for the Video sir...
It's working for me with less data, but not working on huge data..........
any reason........... Its not showing the data name i mean the one you named dummy....
Plz help me...
+Md Zahed Ali Hi. I need to see your workbook. Upload it to OneDrive and share the download link here.
What do I do if when I go to create a new sheet and dont find import from other sources?
Have you tried going to Data > Get Data > From Other Sources.
one more thing any tutorial you recommend for power pivot (basics to advances)
+Vikas Goel I do not know of any such tutorial. I have answered a fair number of questions on using the PowerPivot tool in the Knowledge base section of my website - www.ashishmathur.com/corporate-interventions/
Hi this is a great tips! however I get an error message "syntax error, incomplete clause". what does it means exactly? where did I did wrong?
+Jean Neo Hi, Thank you. Please share the query that you have written.
My query :
Select * from test1
Union all
Select * from test2
Union all
Select * from test3
Union all
Select * from test4
Union all
Select * from test5
Union all
+Jean Neo Remove the last union all. End the statement as test5.
Great video, but i have issue. Syntax error in FROM clause!
Hi. Follow the instructions shared in this Blog article - www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-the-same-workbook/
Omg you are my héroe!
Thank you for your kind words
Hi .. I like to make another pivot table in the same sheet with my first pivot table but with different source data.. can you help me? I cant get it through..
Hi. Not clear about your query. Please share more details.
What can I do if the number of columns does not match between my data sources? Thanks
Hi,
You will have to ensure that. If the number of columns are not the same, then Power Query can help.