Forum Discussion
Help on Combining Data from Multiple Worksheets into a Single Worksheet in Excel
Hi, I have this spreadsheet that I am working on and it contains multiple worksheets of data. I would like to combine all that data into one and create PivotTables out of them. I would also like to ...
You skipped few steps. Here
click on Edit, not on Combine (in my version this button is Transform Data). After that approximately as in my previous post, perhaps your user interface is slightly different.
SergeiBaklan okay so I did that but I keep getting nulls...I don't get why because those files don't have any empty fields. This is what my issue was before.