Forum Discussion
combine multiple excel files
hello every one,
i have a lot of files with the same format.
every file have 2 sheets. sheet for every test i made.
i want to copy part of the data (under Vcollector and under Icollector) in th...
hello wyn,
why is the tables is append below the previous table and not beside the table?
i dond fully understand what you done, did you copy only the requested coulmn or all the table as is?
Tsuriel :)
- Hi Tsuriel
I've used Power Query to pick the required columns from the files (you mention you have multiple files, so I've built it to get the data from all the files in a particular folder)
The data from each sheet is then appended on top of each other to give you a single data set.
You could then use Pivot Tables to slice and dice the data
Were you wanting something else?i understand :)
how can i modify which coulmn to take?
If you go to Data > Queries and Connections and then double click on the Transform Sample File
Then click on the Rename Column Step and name the columns you want to keep followed by the cog next to the Remove Other Column step