0

I have some data horizontally that I need to make vertical but also keep the first few pieces of information constant; here is an example:

What I have

I want it to look like this:

What I want

The data that I am working with is more complicated than this and will be updated periodically. I was hoping to work with a floating range and the TRANSPOSE function but I can not seem to be able to get the repeating name information to work.

Community
  • 1
  • 1
CAK
  • 1
  • 2
    Welcome to SO. Stack Overflow is not a code for me site. This has been asked and answered many times both with formulas and vba. If you have code that is not working then please post it in the original post and we will help overcome the problem. – Scott Craner Apr 04 '16 at 19:38
  • 1
    http://stackoverflow.com/questions/36365839/excel-macrovba-to-transpose-multiple-columns-to-multiple-rows/36366394?noredirect=1#comment60428750_36366394 – Tim Williams Apr 04 '16 at 19:44
  • Thank you, I have been searching but haven't found this exact answer. – CAK Apr 04 '16 at 19:53
  • Depending on what version of Excel you have, you can use either Power Pivot, or in 2016, Data/Get and Transform/From Table. Then, in the Query editor, just select all columns except the first two, and `Unpivot` – Ron Rosenfeld Apr 04 '16 at 20:18
  • [Why Not Images of Code and Sample Data](http://meta.stackoverflow.com/questions/285551/285557#285557) and [Discourage screenshots of code and/or errors](http://meta.stackoverflow.com/questions/303812). –  Apr 04 '16 at 20:19

1 Answers1

0

I always favour using the Multiple Consolidation Ranges feature of Pivot Tables, as it's so much less complicated for those who are unfamiliar with VBA. Deconstructed many a file with this method.

Simple How-To guide here: http://datapigtechnologies.com/blog/index.php/transposing-a-dataset-with-a-pivottable/

Mikey
  • 143
  • 7