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