Remote Data Mining And Management Job In Data Science And Analytics

EXCEL POWER QUERY MANIPULATION

Find more Data Mining And Management remote jobs posted recently Worldwide

I have an excel data table that i need manipulating (ideally via Excels Power Query).

As youll see in the picture the first column is CODE. that will always be called CODE and will always be the first column.

we then have a repeating series of 3 columns (GBP, USD EUR) - these could repeat twice or thirty times. Each set relates to a different product (in this case SL, SM, SC and SX).

as an end result i want to keep with a column for CODE and GBP, USD, EUR but i need a new column for PRODUCT and the CODE repeated as many times as necessary depending on however many sets there are.

we cannot assume there wont be other columns between the CODE and the first GBP/USD/EUR series. We can assume the first product will ALWAYS be SL if that helps you automate this with Excels Power Query.

good luck.
About the recuiter
Member since Nov 11, 2022
Naveen Goyal
from Ile-de-France, France

Skills & Expertise Required

Excel VBA Excel Power Query Data Processing

Open for hiringApply before - Sep 22, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.70

Cost

Offer to work on this project closes in 30 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

web designer - Hourly
Software Developer Engineer - Hourly
iOS / Android Mobile Game. 3D and Turn-Based - Hourly
Salesforce / Zoho Developer - Hourly
Amazon Logistics Shipments and Order Fulfillment Specialist - Hourly
Need attorney to file trademark with follow up - Hourly
Email Signature Creation - Fixed
Create a mail chimp subscription Shopify website - Hourly

Similar Projects

Access Database programmer

Create and maintain a claim processing database.

Excel/Access Based tracker

Need excel or access based productivity tracker, which should allow an employee to update projects worked and respective time too. once time entered it should compare with pre updated benchmarks and tell if employee is within or above the benchmark.

Google Sheet and Macro Expert or Developer

Seeking a programmer that is fluent in Google Sheets with experience in Excel + VBA to build complex scripts, macros and pivot tables to build multiple operational and financial spreadsheets (financial calculator, revenue, daily account receivables...read more

Excel Spreadsheet Completion

I have 3-4 excel spreadsheets that need to be finalized, cleaned up and improved. I have the overall idea and concept worked out, as well as most of the formulas and information finished on a couple of them. I have been working on these sheets for th...read more

Creative Data Guru for Brainstorm/Problem Solving Sessions

We are looking for a creative data expert that can work with us to perfect and develop our client-facing dashboard. We are an innovative consulting firm and need someone who will bring a unique perspective to the process. Our main objective is
-...read more