unpivot

Hi, Im doing a time measurement of cycle times per operator. The sheet use to track the time for each name has title rows that describe crane , lane, location where the measurement was taken (see image is the area in the red box). This is done per each operator. I'm trying to unpivot...

Hi Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data. I have tried doing this with pivot/unpivot but struggling to get my head around it...

UNPIVOTHEADERS function replicates the Power Query function "unpivot other columns", from the first column, where row labels expand out with their column values. Functions in this formula: RBYROW, CBYCOL, repeatxtimes (below) =LAMBDA(values,num_repeat, DROP(REDUCE( ""...

I need to use power query to bring the initial format to this format that i have mentioned later, i've tried Merging, Transposing, Promoting Headers and Unpivoting Columns but somehow i'm messing up somehwere. Also need to remove the Random digit values in C column from row 4 to 6. Here's the...

This is the source format i have which i have tried picoting and unpivoting and even transposing for some reason to make it work in the format i have attached below i have even reached a point where my excel looks almost like the output but then the batch numbers are missing...

I am facing a power query challenge. I have a csv file with many line items. The first columns are some material descriptions. The following columns are weekly dates MM/DD, but without year information. The csv file covers around 3 years. Following an example of the structure. Please...

Hi! Can you please help me out with a transpose/unpivot problem ? ? On top of being a total newb in power query, English is not my native language, so i'll try and do my best to be as clear as possible. So, I've gone this far in "cleaning" an extract i've got from a survey about drinks...

Hi I have summarized data in the following format: role 2021 2022 2023 admin 1 2 2 I would like to convert this so it is presented as: role year admin 2021 admin 2022 admin 2022 admin 2023 admin 2023 I've tried PowerPivot and the Unpivot option. That doesn't seem to show...

Hi I have summarized data in the following format: 2021 2022 2023 admin 1 2 2 I would like to convert this so it is presented as: admin 2021 admin 2022 admin 2022 admin 2023 admin 2023 I've tried PowerPivot and the Unpivot option. That doesn't seem to show in this...

Hi, I am using this wholesale customers dataset as an example. Using PQ, I have unpivoted all the columns from Fresh to Delicassen as shown below. What I would like to do next is create a column "Order ID" that would work like an Index column, except it's incrementing by 1 with each new...

Hi , I am very new to power query . I have a raw set of data . In excel I use a three way look up to get the required answer. The attached input file and the related output file after using formula will give you an idea of what I do. Since my actual data set is very large, the formulas take a...

I am trying to import six regional schedules, each with a separate sheet for each week of the month. When I pull all of the sheets in through power query the dates are scattered on various rows throughout the aggregated editor view. Is it possible to unpivot all of the rows with dates to...

Hi Forum, Long time excel user - first post with a Power Query question. I've been gnawing on this problem for days - my head is going numb. Any help offered, gratefully received. Every week, I get a cross tabulated report which I need to unpivot: Ancillary information like Name, Dept,etc -...

Hello all, I have searched for a few days now how to unpivot via VBA. While I have found some helpful information out there, my situation is unique in that the desire is to unpivot nested headers. Horizontal groupings have levels. For example, below is simple example of what I am trying to do...

HI, I have a power query table with payments made on a transaction. I would like to have all payments on one line for each transaction so I can link them to the sales table. But if a customer paid with 2 credit cards in power query it is listed on 2 lines. I was hoping to use the un pivot and...

Hello helpful excel folk! I have been given a data export to cross reference that looks like it was created as some kind of pivot and the only data structures are the cell indents in the first column. I have already used a small VBA script to populate the indent level of the cell data and now...

Hello everyone, So i had been directed to this thread here: https://www.mrexcel.com/forum/excel-questions/783577-unpivot-table-2.html?highlight=unpivot+macro which has a very useful macro for unpivotting data from a table using VBA, works really well and is what i have been looking for, for...

Hello there everyone! I'm in a bit of a kerfuffle... and not really sure how to go about this. I've created a workbook that multiple people will be entering data into and its going to broadcast how many of each insert we will need per month. So right now i have a table that looks like this...

All we got from the client is the final pivot table, we do not the source tabular data. Can I UNpivot it to get back to my raw data? thanks Jeff

SQL View: a view created from SQL query from different tables Unpivot SQL View: and unpivot version of table created in point 1 through power query Report : Desired presentation Objective: adding contribution column next to sales column where contribution is total sales - total prime cost...