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