Looking for help managing some data

have seperate tables with seperate pieces of information that have to be formatted into one data table

nothing too complex

2000fg is what im paying

and moar if need be

shouldnt take anyone with experience handling data

more than 5 minutes to show me

What type of DB are you using? I may be able to help.

lmk

Pm me type of DB and schema

If it's SQL I can help.

so this is the 2 data sets i need to combine into one essentially



but i have like 10000 different car models and skus to enter. so this is a small sample the larger data set is over 10000 cars and 500 skus

I need the break to be | between the skus in the cell
its a CSV file


This post was edited by DEATHNEVER on Dec 26 2018 09:20am

Do you want this done in excel or do you want this done via a program you run? Both are possible and relatively trivial.

I want this done on excel. because i run it in excel.

i want to learn HOW


This post was edited by DEATHNEVER on Dec 26 2018 02:40pm

You can use a table with a data connection to those two csv files, and do a join with an SQL query.

It's a lot of work if you want it precisely as specified for the SKU column in the image, but if you can live with SKU(left) prepended to SKU(right) that should be easy.

This post was edited by Klexmoo on Dec 26 2018 04:38pm

i need it to be precisely the way i said.

could i potentially exclude the extra column and just have it apply to all the same vehicles? and reintegrate the column after?

This post was edited by DEATHNEVER on Dec 28 2018 02:14pm