WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:01.730 align:start position:0%
 
I'm<00:00:00.329><c> going</c><00:00:00.630><c> to</c><00:00:00.719><c> show</c><00:00:00.840><c> you</c><00:00:00.900><c> a</c><00:00:01.020><c> really</c><00:00:01.469><c> cool</c>

00:00:01.730 --> 00:00:01.740 align:start position:0%
I'm going to show you a really cool
 

00:00:01.740 --> 00:00:04.039 align:start position:0%
I'm going to show you a really cool
trick<00:00:01.800><c> for</c><00:00:02.310><c> rearranging</c><00:00:02.639><c> your</c><00:00:03.030><c> data</c><00:00:03.330><c> using</c><00:00:03.990><c> a</c>

00:00:04.039 --> 00:00:04.049 align:start position:0%
trick for rearranging your data using a
 

00:00:04.049 --> 00:00:04.789 align:start position:0%
trick for rearranging your data using a
feature<00:00:04.290><c> called</c>

00:00:04.789 --> 00:00:04.799 align:start position:0%
feature called
 

00:00:04.799 --> 00:00:07.730 align:start position:0%
feature called
transpose<00:00:05.580><c> I</c><00:00:06.020><c> have</c><00:00:07.020><c> a</c><00:00:07.109><c> list</c><00:00:07.319><c> of</c><00:00:07.440><c> cakes</c>

00:00:07.730 --> 00:00:07.740 align:start position:0%
transpose I have a list of cakes
 

00:00:07.740 --> 00:00:10.129 align:start position:0%
transpose I have a list of cakes
arranged<00:00:08.250><c> into</c><00:00:08.550><c> two</c><00:00:08.760><c> rows</c><00:00:08.970><c> with</c><00:00:09.599><c> the</c><00:00:09.660><c> price</c>

00:00:10.129 --> 00:00:10.139 align:start position:0%
arranged into two rows with the price
 

00:00:10.139 --> 00:00:12.440 align:start position:0%
arranged into two rows with the price
below<00:00:10.410><c> each</c><00:00:10.769><c> cake</c><00:00:11.219><c> name</c><00:00:11.519><c> and</c><00:00:12.360><c> this</c>

00:00:12.440 --> 00:00:12.450 align:start position:0%
below each cake name and this
 

00:00:12.450 --> 00:00:14.509 align:start position:0%
below each cake name and this
arrangement<00:00:12.990><c> is</c><00:00:13.110><c> not</c><00:00:13.380><c> ideal</c><00:00:13.620><c> because</c><00:00:14.099><c> if</c><00:00:14.400><c> I</c>

00:00:14.509 --> 00:00:14.519 align:start position:0%
arrangement is not ideal because if I
 

00:00:14.519 --> 00:00:16.310 align:start position:0%
arrangement is not ideal because if I
add<00:00:14.670><c> more</c><00:00:14.880><c> cake</c><00:00:15.179><c> types</c><00:00:15.480><c> I'm</c><00:00:15.690><c> going</c><00:00:16.049><c> to</c><00:00:16.109><c> have</c><00:00:16.230><c> to</c>

00:00:16.310 --> 00:00:16.320 align:start position:0%
add more cake types I'm going to have to
 

00:00:16.320 --> 00:00:18.769 align:start position:0%
add more cake types I'm going to have to
do<00:00:16.440><c> a</c><00:00:16.470><c> lot</c><00:00:16.890><c> of</c><00:00:16.920><c> horizontal</c><00:00:17.490><c> scrolling</c><00:00:17.789><c> so</c><00:00:18.660><c> I'd</c>

00:00:18.769 --> 00:00:18.779 align:start position:0%
do a lot of horizontal scrolling so I'd
 

00:00:18.779 --> 00:00:20.599 align:start position:0%
do a lot of horizontal scrolling so I'd
like<00:00:18.930><c> to</c><00:00:18.990><c> rearrange</c><00:00:19.439><c> it</c><00:00:19.800><c> into</c><00:00:20.130><c> two</c><00:00:20.369><c> columns</c>

00:00:20.599 --> 00:00:20.609 align:start position:0%
like to rearrange it into two columns
 

00:00:20.609 --> 00:00:23.120 align:start position:0%
like to rearrange it into two columns
instead<00:00:21.090><c> and</c><00:00:21.480><c> Excel</c><00:00:22.260><c> can</c><00:00:22.439><c> actually</c><00:00:22.769><c> do</c><00:00:22.949><c> this</c>

00:00:23.120 --> 00:00:23.130 align:start position:0%
instead and Excel can actually do this
 

00:00:23.130 --> 00:00:27.700 align:start position:0%
instead and Excel can actually do this
automatically<00:00:24.199><c> first</c><00:00:25.199><c> select</c><00:00:25.769><c> the</c><00:00:25.920><c> data</c><00:00:26.099><c> and</c>

00:00:27.700 --> 00:00:27.710 align:start position:0%
automatically first select the data and
 

00:00:27.710 --> 00:00:32.089 align:start position:0%
automatically first select the data and
then<00:00:28.710><c> press</c><00:00:29.010><c> ctrl</c><00:00:29.580><c> C</c><00:00:29.939><c> to</c><00:00:29.970><c> copy</c><00:00:30.390><c> it</c>

00:00:32.089 --> 00:00:32.099 align:start position:0%
then press ctrl C to copy it
 

00:00:32.099 --> 00:00:33.860 align:start position:0%
then press ctrl C to copy it
and<00:00:32.669><c> then</c><00:00:32.790><c> choose</c><00:00:33.030><c> a</c><00:00:33.060><c> cell</c><00:00:33.390><c> where</c><00:00:33.630><c> you'd</c><00:00:33.750><c> like</c>

00:00:33.860 --> 00:00:33.870 align:start position:0%
and then choose a cell where you'd like
 

00:00:33.870 --> 00:00:35.600 align:start position:0%
and then choose a cell where you'd like
to<00:00:33.930><c> paste</c><00:00:34.260><c> it</c><00:00:34.500><c> and</c><00:00:34.680><c> this</c><00:00:35.190><c> needs</c><00:00:35.400><c> to</c><00:00:35.520><c> be</c>

00:00:35.600 --> 00:00:35.610 align:start position:0%
to paste it and this needs to be
 

00:00:35.610 --> 00:00:37.160 align:start position:0%
to paste it and this needs to be
somewhere<00:00:36.000><c> outside</c><00:00:36.450><c> your</c><00:00:36.690><c> original</c>

00:00:37.160 --> 00:00:37.170 align:start position:0%
somewhere outside your original
 

00:00:37.170 --> 00:00:41.119 align:start position:0%
somewhere outside your original
selection<00:00:38.390><c> right-click</c><00:00:39.390><c> the</c><00:00:39.540><c> cell</c><00:00:39.780><c> and</c><00:00:40.129><c> then</c>

00:00:41.119 --> 00:00:41.129 align:start position:0%
selection right-click the cell and then
 

00:00:41.129 --> 00:00:46.100 align:start position:0%
selection right-click the cell and then
under<00:00:41.460><c> paste</c><00:00:41.790><c> options</c><00:00:42.420><c> select</c><00:00:43.050><c> transpose</c><00:00:45.110><c> so</c>

00:00:46.100 --> 00:00:46.110 align:start position:0%
under paste options select transpose so
 

00:00:46.110 --> 00:00:47.840 align:start position:0%
under paste options select transpose so
you<00:00:46.200><c> can</c><00:00:46.379><c> see</c><00:00:46.590><c> it's</c><00:00:46.739><c> the</c><00:00:46.890><c> exact</c><00:00:47.340><c> same</c><00:00:47.579><c> data</c>

00:00:47.840 --> 00:00:47.850 align:start position:0%
you can see it's the exact same data
 

00:00:47.850 --> 00:00:49.910 align:start position:0%
you can see it's the exact same data
it's<00:00:48.510><c> just</c><00:00:48.629><c> sort</c><00:00:49.019><c> of</c><00:00:49.140><c> flipped</c><00:00:49.530><c> on</c><00:00:49.680><c> its</c><00:00:49.710><c> side</c>

00:00:49.910 --> 00:00:49.920 align:start position:0%
it's just sort of flipped on its side
 

00:00:49.920 --> 00:00:54.259 align:start position:0%
it's just sort of flipped on its side
and<00:00:50.390><c> it</c><00:00:51.390><c> even</c><00:00:51.600><c> kept</c><00:00:51.840><c> the</c><00:00:51.900><c> formatting</c><00:00:53.059><c> we</c><00:00:54.059><c> don't</c>

00:00:54.259 --> 00:00:54.269 align:start position:0%
and it even kept the formatting we don't
 

00:00:54.269 --> 00:00:56.570 align:start position:0%
and it even kept the formatting we don't
need<00:00:54.420><c> the</c><00:00:54.600><c> original</c><00:00:55.019><c> data</c><00:00:55.230><c> so</c><00:00:55.920><c> we</c><00:00:56.250><c> can</c><00:00:56.370><c> just</c>

00:00:56.570 --> 00:00:56.580 align:start position:0%
need the original data so we can just
 

00:00:56.580 --> 00:00:59.780 align:start position:0%
need the original data so we can just
select<00:00:56.790><c> these</c><00:00:57.239><c> rows</c><00:00:57.600><c> and</c><00:00:58.250><c> right-click</c><00:00:59.250><c> to</c>

00:00:59.780 --> 00:00:59.790 align:start position:0%
select these rows and right-click to
 

00:00:59.790 --> 00:01:02.520 align:start position:0%
select these rows and right-click to
delete<00:01:00.180><c> them</c>

00:01:02.520 --> 00:01:02.530 align:start position:0%
 
 

00:01:02.530 --> 00:01:05.189 align:start position:0%
 
and<00:01:02.620><c> that's</c><00:01:03.280><c> it</c><00:01:03.520><c> now</c><00:01:04.360><c> you</c><00:01:04.420><c> probably</c><00:01:04.960><c> won't</c>

00:01:05.189 --> 00:01:05.199 align:start position:0%
and that's it now you probably won't
 

00:01:05.199 --> 00:01:07.469 align:start position:0%
and that's it now you probably won't
need<00:01:05.409><c> to</c><00:01:05.560><c> use</c><00:01:05.710><c> this</c><00:01:05.860><c> feature</c><00:01:06.070><c> every</c><00:01:06.640><c> day</c><00:01:06.850><c> but</c>

00:01:07.469 --> 00:01:07.479 align:start position:0%
need to use this feature every day but
 

00:01:07.479 --> 00:01:09.060 align:start position:0%
need to use this feature every day but
when<00:01:07.780><c> you</c><00:01:07.869><c> do</c><00:01:08.020><c> need</c><00:01:08.200><c> it</c><00:01:08.320><c> you'll</c><00:01:08.560><c> be</c><00:01:08.710><c> glad</c><00:01:08.920><c> you</c>

00:01:09.060 --> 00:01:09.070 align:start position:0%
when you do need it you'll be glad you
 

00:01:09.070 --> 00:01:10.859 align:start position:0%
when you do need it you'll be glad you
know<00:01:09.220><c> it</c><00:01:09.520><c> because</c><00:01:09.820><c> it's</c><00:01:09.850><c> a</c><00:01:10.060><c> lot</c><00:01:10.240><c> faster</c><00:01:10.750><c> than</c>

00:01:10.859 --> 00:01:10.869 align:start position:0%
know it because it's a lot faster than
 

00:01:10.869 --> 00:01:15.790 align:start position:0%
know it because it's a lot faster than
rearranging<00:01:11.500><c> everything</c><00:01:11.979><c> by</c><00:01:12.190><c> hand</c>

00:01:15.790 --> 00:01:15.800 align:start position:0%
 
 

00:01:15.800 --> 00:01:18.160 align:start position:0%
 
Goodwill<00:01:16.580><c> Community</c><00:01:17.060><c> Foundation</c><00:01:17.720><c> creating</c>

00:01:18.160 --> 00:01:18.170 align:start position:0%
Goodwill Community Foundation creating
 

00:01:18.170 --> 00:01:21.400 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:18.770><c> for</c><00:01:18.980><c> a</c><00:01:19.040><c> better</c><00:01:19.190><c> life</c>