0:00
hello and welcome to Tel's point in this
0:03
video you are going to learn how to
0:05
combine multiple Excel data sheets into
0:08
one data sheet using power carry now
0:11
here we have an example of this
0:13
Warehouse data we have Warehouse name
0:15
product ID product name stock quantity
0:18
reorder level same is the data for
0:20
warehouse B then for warehouse C and
0:23
then for warehouse D now our task is to
0:26
combine all of these warehouses data
0:28
into one EXC sheet using excel's power
0:31
carry so without wasting time let's get
0:35
started now to create a new Excel sheet
0:38
that will hold all of the combined data
0:41
we are going to create on this file
0:43
option and then here we have the blank
0:46
workbook I'll click on it to create a
0:47
new Excel sheet now we are going to
0:50
import all of this Warehouse data into
0:53
this Excel sheet all right let me zoom
0:55
in a bit now to import this data or to
0:58
combine this data simp simply here go to
1:00
the data Tab and in the data tab use
1:03
this get data option click on it and
1:07
then select from file and then from
1:09
Excel workbook because our data is in
1:12
another Excel workbook right so I'll
1:17
it and here we have to give the location
1:21
so my workbook is on the desktop in this
1:26
carry so this is the location of my
1:30
source workbook where all the warehouse
1:32
data is so I'll just select it and click
1:38
import once I click on import you will
1:41
see a new menu popup which is the
1:43
Navigator menu now in the Navigator menu
1:46
you will see all of your data this is
1:48
Warehouse a b c and d right so just
1:52
click on anyone we want all of these
1:54
right so we will just click on anyone
1:56
for now and then click here on transform
1:59
data because we organize this data using
2:02
this transform data option so click on
2:05
it this will open the power car editor
2:09
now in the power car editor we have a
2:12
lot of freedom to organize our data let
2:15
me just resize it something like this so
2:19
here we have all the data now this is
2:21
only Warehouse a because we selected
2:23
Warehouse a earlier right so here in the
2:26
applied steps option we are going to
2:29
undo some of these steps to go back to
2:31
source so I'll just click on this red
2:33
colored cross and here again and then
2:36
here again and we are back at the source
2:39
and in the source we have all of these
2:42
data tables we have Warehouse a b c and
2:45
d now here I don't want all of these
2:48
columns we only want the names and the
2:50
data in it we don't want this item kind
2:52
and hidden to basically remove these we
2:55
can just simply click on manage columns
3:00
columns and in the choose columns we
3:03
just only want a name and data so we'll
3:05
just uncheck these three and click on
3:08
okay once we do we have these two data
3:11
tables now in the data this one as you
3:14
can see this is expandable that means we
3:16
have much more data in it so we can just
3:18
expand it using this button I'll click
3:21
on it and it gives us the option to
3:23
expand all the columns so yeah I want
3:26
all the columns to be expanded so click
3:30
once you click on okay as you can see we
3:32
have all the data here this is the
3:34
warehouse a if we scroll down as you can
3:37
see we will have the warehouse B option
3:40
and then so on up to Warehouse T all
3:43
right now here notice something these
3:45
headers are name data column 1 data
3:48
column 2 we don't want them right we
3:50
instead want this column to be named
3:51
product ID this column to be named
3:54
product name so to change this we have a
3:57
simple option here and that option is to
4:01
use first row as headers here so I'll
4:04
just click on it and as you can see this
4:07
problem is also fixed now notice here
4:09
there are two two options here we have
4:11
Warehouse a then we have Warehouse name
4:13
we don't want this one right we already
4:15
have this one here so I'm just going to
4:17
right click on this one and then click
4:19
on remove once we click on remove we can
4:22
simply import this data but we we should
4:24
check it again so let me just scroll
4:27
down and let's see if we have the
4:28
warehouse B and if we scroll down here
4:31
we have the warehouse B but notice
4:33
Warehouse B's headers are also here
4:36
right so we need to get a rid of this so
4:39
what we'll do is here in the warehouse
4:41
name there is this filter arrow click on
4:43
it and we'll just uncheck this Warehouse
4:47
name option now if I click on okay and
4:51
if we check again if that row is deleted
4:54
let me scroll down as you can see after
4:56
Warehouse a we have Warehouse B so we
4:59
have all the data here if you want to
5:01
remove or modify or organize in any
5:03
other way with your own data set you
5:05
have all of these options as you can see
5:07
here by clicking on these arrows all
5:10
right but this data is good enough for
5:12
us so we want to import it into our new
5:15
Excel file so here simply click on this
5:18
icon which says close and load so I'll
5:21
just click on it and this may take a
5:24
couple of seconds and as you can see all
5:26
of the data is imported let me zoom in a
5:29
bit as you can see it says 398 rows are
5:33
loaded now if we scroll down to check we
5:35
have all Warehouse a b then we have C
5:38
and D let me just go back up so this is
5:42
how you use power carry to combine
5:44
multiple Excel sheets into
5:47
one so that will be enough for this
5:50
video you can download this practice
5:52
sheet in the link in the description
5:54
below make sure to like this video share
5:57
it with your friends and I will see you
