0

I am having following data in an excel sheet:

enter image description here

Now i need to transpose the data in such a way that i get the following result: enter image description here

I am having a very huge data set like this in excel(thousands of dealer numbers). So manually transposing each and every dealer is not possible.

Can anyone help me out here?

Thanks in Advance!!

Community
  • 1
  • 1
Vaishak
  • 607
  • 3
  • 8
  • 30
  • Chris, is it really a duplicate? They're not asking for a vba code. anyway, @Vaishak, you can simply pivot it, and copy the transposed table for further transformations if it's a one-off analysis. – Lana B Feb 16 '17 at 11:23

1 Answers1

1

If you use the transpose function, passing it the range that you are wanting to transpose and press Crtl +Shift + Enter then you should get the result that you are looking for. If the result is to small you can drag and change the result area, press Crtl + Shift + Enter again and the formula should recalculate your transpose.

=TRANSPOSE(A1:C2) will look like {=TRANSPOSE(A1:C2)} in the formula bar once Crtl +Shift + Enter have been pressed and the function has executed.

Microsoft Documentation for Transpose function

screen shot of simple result

SMAG
  • 652
  • 6
  • 12