How to drag and move rows in pivot table
How to manually move columns in a pivot table in Excel video #excel #pivottable #columns
Timecodes:
hey everyone today i wanted to show you
tip in excel in rearranging or sorting
your columns in pivot tables if you've
ever created a pivot table and you've
had a situation where
you know your columns are supposed to be
in some sort of order but like this that
i have here i've manipulated some dummy
data here in order 2019 is not where it
should be it can be kind of frustrating
trying to figure out how do i get this
to go correctly so it's all
chronological and the data shows up
correctly here so this is a very very
simple fix there's a couple things you
can do you can right right click on your
column headers there and you can go to
sort and you can sort a to z and it
should adjust
correctly but let's say you're doing
that this still isn't working there's
probably something
wrong with your data but you don't
necessarily
need to go and figure out what it is so
if that doesn't work there's something
else that you can do what i'm going to
do here i'm just going to sort it again
from a to z
and something you can do like there
there's this other feature here sort you
can go to more sort options
and then manual you can drag items to
rearrange them
you can hit okay you don't necessarily
need to do that but all you need to do
is just hover over the column that you
want to move and then you'll click on it
and you'll drag it and once you see that
green line pop up
you can move it
to where you need need to go so we can
drop the 2019 right after 2020 and voila
everything is in order and it's gonna
it's gonna work great so you'll have all
of your your data in the order that you
want if you wanted to adjust 2020 for
whatever reason and put that at the
beginning of the pivot table you can do
that it's very very flexible you can you
can go ahead and manipulate the columns
as you see fit they don't necessarily
need to be in any sort of order so it's
very helpful very easy to do and a very
quick little tip to help in creating and
manipulating data in pivot tables so i
hope this was helpful let me know if you
have any additional questions here and
please subscribe to the excel guy thanks
and have a great day
Related queries:
how to drag and drop pivot table rows
how to drag rows in pivot table
how to move rows in pivot table
![How to Reorder Columns or Rows for Pivot Table in Excel. [HD]](https://img.youtube.com/vi/5iWhP0D8LoI/mqdefault.jpg)
