I have data that is situated in a horizontal fashion. (see attachment). I want to show the Row and its corresponding values going down but only show the values labels for those that are not blank. I think if you will look at my attachment, it will make sense. Is this doable in a pivot table? Note that in my real file have many, many columns. I want to eliminate those that are blank for that row header. The highlighted values are the ones that I am referring to, but this will change based on the data.
Bookmarks