I'm going to show you a really cool
trick for rearranging your data using a
feature called
transpose I have a list of cakes
arranged into two rows with the price
below each cake name and this
arrangement is not ideal because if I
add more cake types I'm going to have to
do a lot of horizontal scrolling so I'd
like to rearrange it into two columns
instead and Excel can actually do this
automatically first select the data and
then press ctrl C to copy it
and then choose a cell where you'd like
to paste it and this needs to be
somewhere outside your original
selection right-click the cell and then
under paste options select transpose so
you can see it's the exact same data
it's just sort of flipped on its side
and it even kept the formatting we don't
need the original data so we can just
select these rows and right-click to
delete them
and that's it now you probably won't
need to use this feature every day but
when you do need it you'll be glad you
know it because it's a lot faster than
rearranging everything by hand
Goodwill Community Foundation creating
opportunities for a better life