rotate data in excel with Transpose

rotate data in excel with Transpose

 

today we’ll learn about how to transpose
your data in Excel or how to arrange
your data from horizontal to vertical
there are mainly three ways to do it one
is fixed and other two is dynamically
select your data ctrl C for copy then
select the cell go to Home tab and paste
then transpose but this method is not
dynamic as you can see if I change it to
98 it’s not changing the second method
is using transpose function you need to
know the number of rows and columns so
we have 19 rows and 3 columns so select
19 columns and 3 rows is equal then
transpose then select your data
close the parentheses then control shift
enter the first one was fixed but the
second was is dynamic let’s check you
see it’s dynamic the transpose function
work with array so if we select a straw
or columns we’ll get this extra data who
is not exist if you want to delete it
you cannot delete it because is the part
of transpose array it’s like a train
that 1st and 3rd cargo have peoples but
the second one have nothing but still
you cannot remove it the third one is
not a function or a feature from itself
but it dynamic and easier than the upper
two and it don’t have this limit so our
starting data salesperson is on sale a
one product B 1 and unit C 1 put them
here now put something in front of it
excess ll it’s up to you what you want
to put here so we have 19 rows gravy
so n19 do same for the lower one select
any cell upper side of the studying data
ctrl + f then replace search for XX
search for XX in el replace with equal
replace them all so done and this is
dynamic – let’s check it
one underneath
so guys if you have any question leave a
comment below and give a thumbs up

Leave a comment

Your email address will not be published. Required fields are marked *