+ Reply to Thread
Results 1 to 2 of 2

Pivoting data

  1. #1
    Registered User
    Join Date
    06-20-2018
    Location
    Utah
    MS-Off Ver
    2013
    Posts
    2

    Pivoting data

    Hello,

    New here and just had a quick question.....

    Ive got a set that looks like this

    Country: Male: Female: PercentMale: PercentFemale:
    Italy 8 12 40 60
    France 11 9 55 45
    Germany 10 10 50 50


    and what I would really like is this:

    Country: MaleFemale: Percent:
    Italy Male 40
    Italy Female 60
    France Male 55
    France Female 45
    Germany Male 50
    Germany Female 50

    Is this doable?

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Pivoting data

    is that what you want?

    done with PowerQuery

    Power Query for
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. New to Excel: Pivoting alpha data
    By Susan W in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-09-2016, 09:36 AM
  2. Replies: 3
    Last Post: 01-07-2014, 06:13 AM
  3. Rotate charts without pivoting the data
    By SNLGomes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-23-2012, 04:56 AM
  4. run-time error 5 in the macro for pivoting the sheet data
    By kunwar.singh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 04:22 AM
  5. Pivoting
    By sandra.blackman in forum Excel General
    Replies: 1
    Last Post: 02-27-2009, 03:24 PM
  6. Replies: 1
    Last Post: 02-27-2009, 03:18 PM
  7. "Rotating" / Pivoting / tranforming Data
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-27-2005, 09:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1