Рет қаралды 176,650
How to put lots of text files into a single excel spreadsheet all in one go.
Sometimes you have data in lots of separate text files and you want to be able to put that data together in an excel document without having to copy and paste each text file individually. You can do this using Power Query. This is a really useful feature in Excel 2016 which lets you organize large amounts of data. This only works if all your text files have the same columns. This works with .txt and .csv files.
---------------------------------------------------------------------------------
#exceltutorial #powerquery #exceltipsandtricks
SUBSCRIBE: goo.gl/c46YPs
VIDEO INFO: These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE:
- How to combine tables side by side in excel • How to combine tables ...
- How to combine tables with different columns in excel? • How to combine tables ...
- How to rename multiple files in Windows • How to rename multiple...