"Main Pivot Table"

[nee]

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

 

[p45cal]

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

??