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. 🤔
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.
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...
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:
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)
Months From 1st Purchase
Number of Customers 2nd Order
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 |...