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.

Improve this question
5
  • 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. Commented Apr 4, 2016 at 19:38
  • 1
    stackoverflow.com/questions/36365839/… Commented Apr 4, 2016 at 19:44
  • Thank you, I have been searching but haven't found this exact answer. Commented Apr 4, 2016 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 Commented Apr 4, 2016 at 20:18
  • Why Not Images of Code and Sample Data and Discourage screenshots of code and/or errors. Commented Apr 4, 2016 at 20:19

1 Answer 1

Reset to default
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/

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.