I have two columns in Excel of the same type of variable called Reduced Store Numbers
and Original Store Numbers
. Reduced Store Numbers
has fewer rows than `Original Store Numbers.
I want Original Store Numbers
, Sunday
, Monday
, and Tuesday
reduced to the same rows as Reduced Store Numbers
. Is there a function to do that?
Here's a sample of the dataset:
Reduce Store Numbers Original Store Numbers Sunday Monday Tuesday
1 1 0 19 20
2 2 0 0 12
3 3 0 300 45
4 4 0 5000 100
7 5 0 25 150
7 0 30 25
Desired dataset:
Reduce Store Numbers Original Store Numbers Sunday Monday Tuesday
1 1 0 19 20
2 2 0 0 12
3 3 0 300 45
4 4 0 5000 100
7 7 0 30 25
I have not tried anything and do not know where to start. The original dataset is a larger size than the one posted here.