Find more Data Mining And Management Remote Jobs posted recently Worldwide

EXCEL POWER QUERY MANIPULATION - Posted By Naveen Goyal on Aug 23, 2024

Posted at - Aug 23, 2024

Toogit Instant Connect Enabled


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

As you'll 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 recuiterMember since Nov 11, 2022 Naveen Goyal
from Ile-de-France, France

Skills & Expertise Required

Excel VBA Excel Power Query Data Processing 

Candidate shortlisted and hiredHiring open till - Sep 22, 2024

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$26.66
Cost

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


Apply on more work from home jobs posted in Data Mining And Management category.


Related Jobs


Latest In Excel VBA Jobs


Latest In Excel Jobs


Latest In Power Query Jobs


Latest In Data Processing Jobs