I need help using power query to transform a job card which has a mixed tabular and pivoted format. I will be transforming these from a sharepoint folder. I don't need the whole solution, just a demo of the transformation steps to combine say 2-3 of these documents into a tabulated excel spreadsheet. I would then use this to connect to a sharepoint folder for progressive adding of these data points to the spreadsheet over time.
My service Areas: · Advanced Formulas >> Nested Loop>> VLOOKUP, HLOOKUP, INDEX, MATCH, IF, OR, AND, NOT, IFERROR, LEFT, RIGHT, LEN, MID, FIND, SUBSTITIUTE, CONCATENATE, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, LARGE, Daha Fazla
Bu iş için 33 freelancer ortalamada $127 teklif veriyor
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project. I'm so responsible and kind, I'll always send you the files on time and Daha Fazla
Hello, I hope you're doing really well. We are reviewing your requirements and we can do this work. We are a team of highly skilled individuals having 8+ years of experience in the IT Industry. We have worked with Mi Daha Fazla
I am ready to provide you the solution to combine and transform to Desired Output format from desktop folder using Power queries. Please message me in chat box. Thanks.
Hey Mate, We have gone through the sample data & we are perfect match for this job need to get the actual data so that we can start working on this report. Lets Chat & discuss this further in detail. Cheers
friend, I can solve this problem, and once and for all automate it so that you can access it from your smartphone and from your pc, through appsheet. contact me.
Hello, I am Usman Noor , a Preferred Freelancer and 10+ year professional specializing in Accounting, Finance, and Quickbooks. Here on Freelancer, I have completed over 100 projects with a 5 star average rating and num Daha Fazla
Hello, I have worked previously on these type of projects. I hope to help you with this too and give my best.
Hello i am sujeet kumar. I have read your project description and i am interested in your work. sir i am not a very experiences man but i am very hard working man.
I have experience of same with share point excel and flow. Need your system access for this work or need to create temporary login id to work on this project Thanking you