I have the situation as show below. There are groups of rows. Above each group is a small "header" describing a data field that all the rows in the group have in common. I want to create a pivot table of everything and include that field (GroupID), hence I want the second version of the table. Is there a way of doing this short of recording a macro? Or is there perhaps a way of creating the pivot table directly?
GroupID 4 Name Email Likes Dislikes herpina something Cake Excel derpina something Cake Excel GroupID 5 Name Email Likes Dislikes roflmao something Cake Hmm roflomg something Baking test testtttt something Sleep 22 GroupID 1 Name Email Likes Dislikes OAG something OAB N/A OAB something N/A N/A
Name Email Likes Dislikes GroupID herpina something Cake Excel 4 derpina something Cake Excel 4 roflmao something Cake Hmm 5 roflomg something Baking test 5 testtttt something Sleep 22 5 OAG something OAB N/A 1 OAB something N/A N/A 1
This sample input is also located at https://dl.dropbox.com/u/736090/Book1.xlsx