+ Reply to Thread
Results 1 to 2 of 2

Flatten/ de-pivot

  1. #1
    Registered User
    Join Date
    08-18-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    1

    Flatten/ de-pivot

    Help.jpgHelp.jpg

    Hi, does anyone know how to flatten a spreadsheet like the top table in the attachments?

    Turn into something similar like the table below?

    It's a large file with over 5 thousand rows!

    Thank you.

    CC

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Flatten/ de-pivot

    PowerQuery can do it, as can double clicking on the data, depending on what you are using and what you are trying to accomplish.

    Obviously VBA can do it.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. Flatten a Crosstable
    By jiggaboi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-04-2013, 03:25 PM
  2. Flatten Data Script
    By JimmyA in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-15-2011, 12:08 PM
  3. How to 'flatten' a set of values
    By JosVL in forum Excel General
    Replies: 3
    Last Post: 12-04-2009, 04:50 AM
  4. Flatten password file
    By PhilSM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2009, 07:59 PM
  5. [SOLVED] flatten pivotTable
    By aaron.kempf@gmail.com in forum Excel General
    Replies: 5
    Last Post: 01-14-2005, 06:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1