Closed

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.

Skills: Data Entry, Data Processing, Excel, Software Architecture, Visual Basic

See more: 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

About the Employer:
( 0 reviews ) Mumbai, India

Project ID: #17835429

17 freelancers are bidding on average ₹1670 for this job

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 More

₹1250 INR in 2 days
(4 Reviews)
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 More

₹1300 INR in 1 day
(1 Review)
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 More

₹1000 INR in 0 days
(7 Reviews)
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 More

₹8888 INR in 1 day
(7 Reviews)
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 More

₹1300 INR in 1 day
(5 Reviews)
2.0
₹1300 INR in 3 days
(0 Reviews)
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 More

₹1300 INR in 7 days
(0 Reviews)
0.0
₹1300 INR in 1 day
(0 Reviews)
0.0
₹1050 INR in 1 day
(0 Reviews)
0.0
ahmedsaad555999

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

₹1050 INR in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0
₹1050 INR in 1 day
(0 Reviews)
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 More

₹1150 INR in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
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 More

₹950 INR in 2 days
(0 Reviews)
0.0
₹1300 INR in 1 day
(0 Reviews)
0.0
ssinghs605

Job will be done on time and with much accuracy

₹1750 INR in 5 days
(0 Reviews)
0.0