unpivot

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

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

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

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

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

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

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

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

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

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

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

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

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