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
Bookmarks