• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

"Main Pivot Table"

nee

New Member
Hi Team.

I need one small advice. .I have few files in each file the no of rows are more than 4 lakh.. so I cant merge them together in one excel as excel has no of rows limitation.. I need to create pivot views.. right now I have to go to each excel and create view and its very manual.. Also since the no of columns are not the same.. I could have used power query but data volume is very high

Any suggestion how to do it

1. I want to merge the columns together. If there are some columns then it should just show as column and value for null for the cases where they have no values
2. I want to create "main pivot tables" so that I can create the view
 
I could have used power query but data volume is very high
That's what Power Query is for - large amounts of data.
Attach a workbook with say at least 20 rows of representative/realistic in each sheet so we can experiment and not have to guess about your layout.
ps. What do you mean by
I have few files in each file
??
 
Back
Top