unpivot

  1. A

    Unpivot and Arrange the data in Sheet1

    Hi All, Please help me unpivot and arrange the data in Sheet1 using power query. My data must look same as in Sheet2.. Mr MarcelBeug helped me in the past and now I am looking forward to his help or some other expert. My file link is here...
  2. B

    Unpivot other columns

    HI I have data in sheet "data" and would like to unpivot them. I click "from table" then highligh "need?" and then go to transform --> "unpivot other columns" Excel cannot unpivot all of the selection and has error at the end of the list. Could anyone help? How can I add attachment? Below...
  3. P

    Help Unpivoting table?

    Hi all, I'm using Excel 2011 on a Mac, I have the Developer tab available. I have a workbook that looks like this: <colgroup><col width="50" span="17" style="width: 50pt;"></colgroup><tbody> Family Genus Species Blood / Heart Teeth / Mouth Guts / Stomach Sexual health Neurological General...
  4. D

    Unpivot VBA Help

    I need assistance with a VBA that will take the sample data provided in the link: https://drive.google.com/open?id=0B4w20SQzW8pCdGZQRFMzUkpnYXc and pivot all of the date columns to look like the data provided in the link: https://drive.google.com/open?id=0B4w20SQzW8pCT3R1WENJQV9DeG8 I would...
  5. S

    Calculating count of 1st occurrence of ACV value in crosstab rows containing variable date headings

    Hi, I have multiple crosstab workbooks like this, each representing ACV data for a particular Category-Country e.g. Foods-US. The workbooks filenames are e.g. INO-Food-US.xlsx INO-Pet Food-US.xlsx INO-CCare-US.xlsx INO-CCare-UK.xlsx INO-Food-UK etc. i can loop thru the folder and import all...
  6. M

    Transform Rows to columns

    Hi! Please help me with my thesis research. I have downloaded huge data set to analyse. For the first step, I want to transform the data. I want dates to be in the rows, and company names to be in the columns. Currently it is like this; Name Date Price Company A...
  7. L

    In VBA, does a check for a value slow down or speed up calculation?

    I have a workbook where there are various groups of cells where users enter values. I have code which translates that worksheet into a nice clean data table. Essentially the code loops through the defined ranges and checks every cell to see if there is a value > 0. If there is a positive...
  8. O

    Unpivot table

    Hello all, I need your help with the following table which is in a matrix format: <tbody> Group ID Group Description Name 1 Title 1 Email 1 Name 2 Title 2 Email 2 Name 3 Title 3 Email 3 </tbody> <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> IT...
  9. Z

    Help With Unpivoting / Stacking Columns

    Hi, I am not a frequent user of VBA, but have been tasked with developing a macro to re-structure survey results for reporting purposes. I was really hoping someone could help me with the code since I'm honestly at a loss at this point. First, I should reference my question is somewhat along the...
  10. D

    Unpivoting Multiple Fields in PowerQuery

    I have just started playing around with PowerQuery and find the features awesome. Doing a normal unpivot has been soooo simplified, but I have been stumped on how to do this particular task. I have tied search this forum and Google, but I have trouble coming up with coherent search criteria to...
  11. G

    Need Help: Reshape Cross table in PowerPivot (unpivot)

    Hello all, I would appreciate any help from you guys who are guru's or anyone else who may have the answer. I am just beginning to learn PowerPivot. I'm hoping that PowerPivot will solve many of the issues I deal with Excel that make me work extra just to do work-arounds. Here's my issue in...
  12. L

    transform table into list - unpivot to table

    Hi All, I have a table of quantity of hearing instruments sold by date that I would like to transform into a list (3 columns): item; date; qty As a total I have: 1. 114 different dates in columns 2. 760 different items in rows Please have a look at the data below PS:I get the xls files in...
  13. F

    transform table into list / how to "unpivot" a table

    Hi All, I have a bit of a challenge for you...at least it is for me :-) I have a table of quantity of cars sold by brand (more than two dimensions) that I would like to tranform into a list (5 columns). Please have a look at the data below Your help is HIGHLY appreciated...as always ;)...

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
Back
Top