title: when I make pivot table it changes the order of rows
body: <p>When I make a pivot table it changes the order of rows.</p>
  
  <p>I have a big dataset. I have 35 industries and 41 countries so I have 35 x 41 = 1441 rows corresponding 16 energy carrier which are my columns. In each country, I have specific first 16 rows. It is very easy working with a pivot table however when I do pivot table it changes the order of rows of the original table. I have two screenshots the first one is the original table and when I make a pivot table it changes the order of the rows. I need the pivot table as the same order of the original table.
  <a href="https://i.stack.imgur.com/i3d81.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/i3d81.png" alt="enter image description here"></a></p>
  
  <p>Trying to use excel pivot table.</p>
  
  <p>No code</p>
  
  <p>I want the same order of the original table in the pivot table. That would help a lot.<a href="https://i.stack.imgur.com/jmfnz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jmfnz.png" alt="enter image description here"></a></p>