maheshexcel
New Member
We have Excel-10, I have two excel Fiiles Containing Data file one 7120000 and 2 515000, want to Merge this files and Then Apply Pivot
Note : Headers are Same
Kindly Guide
Note : Headers are Same
Kindly Guide
2 Excel Merged = data 12 lac+=Apply Pivot = How to do the same
- Thread starter maheshexcel
- Start date
AlanSidman
Well-Known Member
Attach a sample workbook
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Hi:
The only way you can do this in excel is by adding the data set to data model and merging it in power query and use this merged data set to build power pivot. There are a lot of resources available on internet how to do this, please give a google search. Alternatively, if you do not have power query in excel , you can use access to merge the data and link it to excel to create pivot
Thanks
The only way you can do this in excel is by adding the data set to data model and merging it in power query and use this merged data set to build power pivot. There are a lot of resources available on internet how to do this, please give a google search. Alternatively, if you do not have power query in excel , you can use access to merge the data and link it to excel to create pivot
Thanks