+ Reply to Thread
Results 1 to 7 of 7

Flattening a cross Tab Table

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    newcastle
    MS-Off Ver
    Excel 2016
    Posts
    49

    Flattening a cross Tab Table

    Good morning,

    I am looking to produce a dashboard for analysing Incident statistics.

    The data I have been given is in a Cross table format.

    I need to rearrange the data into 4 x columns named "Station" "Meeting date" "Incident Type" "Number of Incidents"

    I have seen macros that can do this but I can't seem to adapt the code to my needs.

    Any help will be gratefully received.

    Many thanks
    Phil
    Attached Files Attached Files
    Last edited by sa1ntj0hn; 11-24-2017 at 08:12 AM.

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Flattening a cross Tab Table

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    01-20-2009
    Location
    newcastle
    MS-Off Ver
    Excel 2016
    Posts
    49

    Re: Flattening a cross Tab Table

    Hi Mike,

    Thanks for the heads up.
    I have now attached a before and after in the example file.

    Thanks
    Phil
    Attached Files Attached Files

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Flattening a cross Tab Table

    Coded this up before I seen your last post.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Flattening a cross Tab Table

    Just remove the If statement from my previous post

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-20-2009
    Location
    newcastle
    MS-Off Ver
    Excel 2016
    Posts
    49

    Re: Flattening a cross Tab Table

    That is brilliant Mike thank you so much for your help.

    Phil

  7. #7
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Flattening a cross Tab Table

    Your Welcome... Thanks for the Rep

+ 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. Powerpoint flattening / merging images into one when saved
    By mailrush in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 09-09-2017, 04:30 PM
  2. Help with flattening a cross table with two groups of data
    By Vaslo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2015, 08:53 AM
  3. [SOLVED] Flattening A File - Awkward Data Output
    By vichisov in forum Excel General
    Replies: 6
    Last Post: 01-22-2015, 02:45 PM
  4. Flattening export file
    By kateyesofblue in forum Excel General
    Replies: 1
    Last Post: 05-30-2012, 06:37 PM
  5. Flattening Data
    By Davywat in forum Excel General
    Replies: 4
    Last Post: 04-25-2012, 03:37 PM
  6. Replies: 2
    Last Post: 09-15-2009, 04:25 PM
  7. flattening aggregated fields in pivot table
    By Randall Arnold in forum Excel General
    Replies: 2
    Last Post: 11-04-2005, 04:47 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