Excel Short cut Question
July 29, 2010 9:47 AM Subscribe
Excelfilter: This may be a long shot, but..... Is there a quick way of formatting a table to group like records under a single heading?
posted by Kurichina to computers & internet (14 answers total) 1 user marked this as a favorite
I'm not sure I'm going to describe this correctly, but I want to change a simple table like this
into a formatted chart like this
. In the past, I've done all this manually, but I'm sure there has to be a quicker way. I'm not familar with macros and the like but I think I could figure them out with a bit instructions. Am I correct in thinking that that's what I need to do? Are there some good resources the hive-mind could point me to? Something that would instruct the program to grab all lines with the value "--" in category A and populate the table under A.