Seem like every project my team is made to assist on is progressively worse in terms of organizational function 
6 Figures 6 Certs Random Thoughts Thread
- Thread starter ProfessionallyTrill
- Start date
Sauce Mane
Superstar
Anyone is good with Excel? I'm pretty decent but I'm stuck with this problem where I need to combine different data together. One sheet has a primary key that's missing some info that the other has. Basically, the main sheet primary key has unnecessary info together with numbers that match another sheet. Not sure how do I combine that together
vlookup is the fastest way I can think of while not having excel handy at the moment.
In your sheet with the primary keep delete the columns that you don't need but obviously keep the primary key that joins the data. In your sheet with the data you need make sure the primary key is the first column.
=vlookup(the primary key in your main tab , this selection will be the table with the data you want including the primary key , this will depend on the column you want. aka if it's the column AFTER the primary key it will be 2, FALSE as this makes it an exact match)
I tried to breakdown the formula in text for you but it usally looks like =vlookup(PrimarySheet!A1,Sheet2!A:D,2,FALSE)
Secure Da Bag
Veteran
Seem like every project my team is made to assist on is progressively worse in terms of organizational function
Out here like Special Forces.
Obreh Cleanfrey
Secure Da Bag
Veteran
Seem like every project my team is made to assist on is progressively worse in terms of organizational function
Out here like Special Forces.
Obreh Cleanfrey
Sauce Mane
Superstar
So here is a preview of a column from one data set (1)
and here's another preview column from another data set (2)
Do you notice how the numbers in the data set (2) match with the ending numbers in the data set (1)? The only difference is data set (1) has extra text, other than that they both share the primary key which is those numbers. So how do I go about joining them? I tried VLOOKUP but it didn't work.
find an option in the ribbon called text to column. you want to put your delimiter as :!So here is a preview of a column from one data set (1)
and here's another preview column from another data set (2)
Do you notice how the numbers in the data set (2) match with the ending numbers in the data set (1)? The only difference is data set (1) has extra text, other than that they both share the primary key which is those numbers. So how do I go about joining them? I tried VLOOKUP but it didn't work.
That will split it from one big string into individual columns
Not in the least bit surprised that our engineering team launched a significant update to our billing system on a weekday against our wishes and it has now locked up our data warehouse for the day 
They trying train the new kids to be comfortable with less.
They trying train the new kids to be comfortable with less.
That's slightly below where I started, and I know I was below market at the time.
I'm on thin ice at work... looking like next month is make or break.
Sn: I got a meeting with a recruiter this afternoon... hopefully there's something good that's less work
Sn: I got a meeting with a recruiter this afternoon... hopefully there's something good that's less work
Secure Da Bag
Veteran
They trying train the new kids to be comfortable with less.
I started way less than that. Even if you adjust for inflation and moving to the east coast.
null
...
So here is a preview of a column from one data set (1)
and here's another preview column from another data set (2)
Do you notice how the numbers in the data set (2) match with the ending numbers in the data set (1)? The only difference is data set (1) has extra text, other than that they both share the primary key which is those numbers. So how do I go about joining them? I tried VLOOKUP but it didn't work.
didn't look at it too much but if the PK is unique in dataset 2 then slice the extra part out of dataset 1's PK and then join on the result
dora_da_destroyer
Master Baker
ok, i truly don't like the person i report to now, and it's only startups hiring, i have no interest in another startup. wish i could pivot to a whole different industry for a few years, but aint trying to take that pay cut
If people knew how shoddy some of the systems are for their most used pieces of technology, we'd be back in the analog age . This shyt I'm seeing is concerning y'all
. This shyt I'm seeing is concerning y'all