Results 1 to 2 of 2

How to clean up data to unpivot it

Threaded View

  1. 09-27-2018, 07:05 AM #1
    ammartino44
    ammartino44 is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    How to clean up data to unpivot it

    Does anyone know how I can unpivot this data with excel power query or regular excel? I want the data to be down the column and the column headers should be row entries.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unpivot data with VBA
    By Anton2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2017, 05:30 AM
  2. [SOLVED] Unpivot data macro
    By logisticsexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2017, 01:17 AM
  3. Reshape data and unpivot
    By hpatel517 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2016, 12:22 PM
  4. Unpivot Data
    By naveeddil in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-07-2015, 08:04 AM
  5. Unpivot and stack data
    By yching in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-14-2015, 05:18 AM
  6. Unpivot Data
    By Olly in forum Tips and Tutorials
    Replies: 0
    Last Post: 04-02-2014, 05:33 PM
  7. [SOLVED] VBA Code to optimize and clean data- clean out numerical/ or symbol
    By tracylsr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2012, 04:21 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1