![]() ![]() If you are on Excel for Mac, and Power Query doesn’t have the From Folder option at the time you read this, my friend Rod showed me a great option for pasting the full path and file name into Excel for Mac. You can also remove any rows you don’t need by using the filter buttons on the columns. In the resulting Power Query window, you can easily delete columns you don’t need (Home > Remove Columns). In the resulting Import Data dialog, select Table and either a new or existing worksheet as desired.Īnd that is what we call mission success □Īs a note, if you wanted to remove any columns or rows, you can click on Transform Data instead of Load. Next, click the down arrow on the Load button and select Load To. You’ll then see a preview screen with a list of the files in that folder and any subfolders, like this: In the resulting Browse dialog, simply browse to the desired folder and click Open. First, click Data > Get Data > From File > From Folder. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |