unstack

I am new to Power Query, and trying to transform the following data to table. Watched few Youtube which only has one column in the example, but this one has three columns. How do I do it, I add the index column, Modulo column, then what's next? Help please Customer # City State 75 Toronto...

Hi, I am working with this dataset that comes in this one-column/unstacked-type format, as shown on left in photo. I think my first step should be to split out a separate column listing location, as shown on right. Basically that means I need to tell Power Query to fill down based on every...

Hi MrExcel Community, I am facing a new unstacking data challenge. ? Context I have a bunch of Property Names, two Attributes which are stacked together in the following order: (1) a date (in a text format) and (2) a percentage change and their Values. Target Here is that table format I am...

Hi Mr Excel Community, I would like to unstack this data using Power Query in order to have a clean list to pivot. Desired situation > To have a table with the following headers: Market, Items, Years, Month, Values. Change vs prior Year will be filtered out of the data sample. I know that I...

Hi all, I need help on a data transformation assignment in Power Query. The goal is to unpivot and unstack data from two tabluar data sets and transform them into a list. Data Source = 2 .xlsx Files in Folder (please see data example below) Data Type = Tablular format with yearly dates on...

I have data that has been stacked prior to my receiving it. There are multiple rows of values for a single unifying ID. I'd like to convert those multiple rows into a single row by adding columns and pulling in a specified range of data. So my initial data looks like: <tbody> ID Name Subject...

Hi I have some data that i need to expand out / unstack in excel with either some VBA or a formula. The data looks like this, (But is variable so will change, the values and the height data) <tbody> Months From 1st Purchase Number of Customers 2nd Order 0 5 1 4 2 5 3 3 4 1 5 6...

I have two Column Labels in my pivot table,(hoping to have about 5 or so) but it seems the data becomes stacked instead of separating the 2. I want my first column Label A to have its 4 columns underneath it without column b Overlapping.this is what i want it to do | A |...