+ Reply to Thread
Results 1 to 2 of 2

Grouping blocks of data

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    13

    Grouping blocks of data

    Hi,

    I have a spreadsheet of list of songs played during hockey games. This list is organized by what portions of the game songs are played in. The list also is single column list of each game played. Therefore I have blocks of similar data that I would like to group together: ie:

    Warm Up
    Back to Back - Drake
    Become the Enemy - Like A Storm
    Blood on the Leaves - Kanye West
    Five Hours - Deorro

    Puck Drop
    We Will Rock You VonLichten- Queen + VonLichten
    Where The Streets Have No Names - U2
    Baba O'Riely - The Who
    .....
    .....
    .....


    For each game in the list there is a Warm Up section, Puck Drop section, In Game sections, and 5 more. I would like to organize all sections into it's own block ie: All Warm Up sections into one block, All Puck Drop sections into one block, All In Game sections into one, and all the other sections into each of it's own block.

    There are roughly 20 games listed in a single column and I'd like to organize by when songs are played.

    Thank you

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: Grouping blocks of data

    I suggest that you upload a sample of the raw data as well as the expected output based on that data.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 4
    Last Post: 07-26-2014, 02:35 AM
  2. [SOLVED] Grouped Data Blocks editted to Columns of Data based off left cell value?
    By BlazzedTroll in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-10-2013, 03:06 PM
  3. Transpose Blocks of Data
    By cpincforum in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-30-2013, 12:52 PM
  4. [SOLVED] Max value between every nth cell - blocks of data
    By sans in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-20-2012, 04:17 PM
  5. [SOLVED] Stuck on how to Reformat data blocks into list with only essential data
    By bnasty in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2012, 04:32 PM
  6. Using macros to identify blocks of data and summarise those blocks
    By gophbeav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2012, 04:35 AM
  7. Copy Blocks Of Data
    By SenojNW in forum Excel General
    Replies: 2
    Last Post: 08-08-2005, 09:06 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