Having trouble combining multiple sharepoint excel files into one

%3CLINGO-SUB%20id%3D%22lingo-sub-2308622%22%20slang%3D%22en-US%22%3EHaving%20trouble%20combining%20multiple%20sharepoint%20excel%20files%20into%20one%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308622%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20have%20used%20share%20point%20for%20a%20while%2C%20but%20really%20never%20for%20anything%20very%20advanced.%20I'm%20hoping%20an%20expert%20here%20would%20be%20willing%20to%20help%20me%20out!%20I%20greatly%20appreciate%20it!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBackground%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20sharepoint%20folder%20with%20excel%20files%20for%20every%20single%20day%20for%20the%20past%20year.%20The%20format%20is%20slightly%20off%20for%20about%2090%20days%2Ffiles.%20My%20A%20column%20needs%20to%20be%20removed%20and%20my%20b%20column%20needs%20to%20have%20the%20date%20in%20a%20different%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20I%20do%20this%2C%20I%20would%20like%20to%20either...%3C%2FP%3E%3CP%3EA.%20combine%20all%20excel%20files%20into%20one%20so%20I%20can%20feed%20my%20Power%20BI%20report%2C%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3EB.%20adjust%20format%20on%20all%2090%20excel%20files%20so%20they%20flow%20with%20the%20rest%20of%20the%20excel%20files%20within%20my%20sharepoint%20folder%20into%20BI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20any%20and%20all%20suggestions.%20Thanks%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2308622%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi there,

 

So I have used share point for a while, but really never for anything very advanced. I'm hoping an expert here would be willing to help me out! I greatly appreciate it!

 

Background:

 

I have a sharepoint folder with excel files for every single day for the past year. The format is slightly off for about 90 days/files. My A column needs to be removed and my b column needs to have the date in a different format.

 

Once I do this, I would like to either...

A. combine all excel files into one so I can feed my Power BI report,

or

B. adjust format on all 90 excel files so they flow with the rest of the excel files within my sharepoint folder into BI.

 

Looking for any and all suggestions. Thanks so much!

0 Replies