unstack

  1. G

    Power Query -- New column fills down every Nth row of existing column

    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...
  2. M

    Power Query - Unstack data

    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...
  3. M

    Power Query: Unstack data

    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...
  4. M

    Power Query: Unpivot + Unstack 2 tabluar Tables into List

    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...
  5. F

    VBA Macro to Unstack Data

    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...
  6. C

    unstack / loop through data repeat number by category value

    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...
  7. R

    Pivot table Column Labels cause cloumn data to stack help!

    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 |...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top