Suljettu

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Mumbai, India

Projektin tunnus: #17835429

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

₹1250 INR 2 päivässä
(4 arvostelua)
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 Lisää

₹1300 INR 1 päivässä
(1 arvostelu)
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 Lisää

₹1000 INR 0 päivässä
(7 arvostelua)
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 Lisää

₹8888 INR 1 päivässä
(7 arvostelua)
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 Lisää

₹1300 INR 1 päivässä
(5 arvostelua)
2.0
₹1300 INR 3 päivässä
(0 arvostelua)
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 Lisää

₹1300 INR 7 päivässä
(0 arvostelua)
0.0
₹1300 INR 1 päivässä
(0 arvostelua)
0.0
₹1050 INR 1 päivässä
(0 arvostelua)
0.0
ahmedsaad555999

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

₹1050 INR 1 päivässä
(0 arvostelua)
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 päivässä
(0 arvostelua)
0.0
₹1050 INR 1 päivässä
(0 arvostelua)
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 Lisää

₹1150 INR 1 päivässä
(0 arvostelua)
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 päivässä
(0 arvostelua)
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 Lisää

₹950 INR 2 päivässä
(0 arvostelua)
0.0
₹1300 INR 1 päivässä
(0 arvostelua)
0.0
ssinghs605

Job will be done on time and with much accuracy

₹1750 INR 5 päivässä
(0 arvostelua)
0.0