終了

extract data from excel files using power query

I want to extract certain set of rows(lets say rows 10-30) from same sheet(lets say sheet "income statement") present in multiple excel files to create a data dump in an automated manner. Also i want to shape the data in a particular way ( basically pivoting and transposing on certain columns). I want to use powerquery (and probably M, if required) for this.

スキル: データ入力, 情報処理, エクセル, ソフトウェアアーキテクチャ, ビジュアルベーシック

さらに表示: extract data mdb files, fetch data excel files, extract data html files php, power query excel 2016, power query combine multiple excel files, power query load multiple files from folder, power query excel.workbook( content ), power query multiple csv files, excel.workbook power query, excel power query, power query combine binaries, extract data excel drop form html, extract data excel tabel, comparing excel files using code, read data excel sheet using save mysql, extract data xml file using 2008, read excel files using netbeans, information multiple excel files using vbnet, change data excel sheet using program, javascript extract data excel

採用者について:
( 0件のレビュー ) Mumbai, India

プロジェクトID: #17835429

17人のフリーランサーが、このジョブに平均₹1670で入札しています

krishnaagr89

Hi,I have read your requirements of extract data from excel files using power query and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to もっと

₹1250 INR 2日以内
(4件のレビュー)
3.0
BonganiMdu

I have done a very similar project like the one being posted here. Please view my profile for a reference from my previous employer who gave me a project here on freelancer.(https://www.freelancer.com/u/BonganiMdu) I もっと

₹1300 INR 1日以内
(レビュー1件)
2.9
paulodayto08

Hi Good Day! I can help you to complete your VBA works in less than a day. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different templ もっと

₹1000 INR 0日以内
(7件のレビュー)
2.8
techobrie

we can extract data from excel files High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly もっと

₹8888 INR 1日以内
(7件のレビュー)
4.3
rubal45

i understand what you need. i can extract it with vba. ping me. i am interested . i can do it. thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks t もっと

₹1300 INR 1日以内
(5件のレビュー)
2.0
₹1300 INR 3日以内
(0件のレビュー)
0.0
jasonfrancisco

Dear Hiring Manager, Good Day! It’s a pleasure to meet [login to view URL] reading on your job post, I believe you are looking for a Certified Virtual Assistant then I can be a great fit. I’ve been trained for 2 months i もっと

₹1300 INR 7日以内
(0件のレビュー)
0.0
₹1300 INR 1日以内
(0件のレビュー)
0.0
₹1050 INR 1日以内
(0件のレビュー)
0.0
ahmedsaad555999

iam accountant and expert in excel .. fast working . perfectly and iam expert in data processing

₹1050 INR 1日以内
(0件のレビュー)
0.0
onlinejobmidhun

I am a professional in data entry and emails managed? If you want your work done, then you are in the right place. Inbox with details of what you want done.

₹1250 INR 1日以内
(0件のレビュー)
0.0
₹1050 INR 1日以内
(0件のレビュー)
0.0
rezhanelicup

I am a graduate of Bachelor of Arts Major in Mass Communication at Adamson University. Professional with Administrative, Marketing, Operations and Sales experience and skills in Construction Industry and Food and Beve もっと

₹1150 INR 1日以内
(0件のレビュー)
0.0
jamalstrictbd

Hi I'm Jamal uddin and working verious types such as Online Data Entry, Data Processing, Excel, Software Architecture, Visual Basic.

₹1200 INR 1日以内
(0件のレビュー)
0.0
razeliebabe18

Hi there, My heart leapt when I saw the position for a data entry on onlinejobs.ph. My name is Razel and I am made for this job. I have 1 year of professional experience as an Administrative Assistant in our Munici もっと

₹950 INR 2日以内
(0件のレビュー)
0.0
₹1300 INR 1日以内
(0件のレビュー)
0.0
ssinghs605

Job will be done on time and with much accuracy

₹1750 INR 5日以内
(0件のレビュー)
0.0