Data Parse / Reference Look for SQL

[toddjennings]

I will see if I can articulate my challenge. I have a large spreadsheet of data that I need to import into an SQL Database. What the problem starts is I had one column of data that contained many reference values. I will try to give an example

Col Col2 Col3 Col4
Row 1 Mr. Smith Red Blue Yellow
Row 2 Mr. Jones Green Red Blue

In SQL I have a "Customer" table which will be the Column1 the customer name and I need to import Col2, Col3, Col4 into a "Lookup Table - Color". With the row number acting as the primary key (PK) for customer

I thought I could somehow tranpose the columns into a new sheet going down with a column for color and one for customer id

Any thoughts on how to approach this problem?

Cheers,

Todd

[aydeegee]

Hi todd

Welcome to the forum.

I'm not sure what you are wanting. Is it
Mr Smith Red
Mr Smith Blue
Mr Smith Yellow
Mr Jones Green

or something else?

Regards
Alastair

[toddjennings]

Yes that is exactly what I am looking to do...Thoughts? Can I hire you to transform some data?

Todd

[aydeegee]

Hi Todd

What is the size of your data? Rows and columns?

Regards
Alastair

[toddjennings]

Rows is about 33k, columns is tricky there are about 90 columns total quite a few seem empty. Though I can pull out the key columns that need to be related to a few sheets with 33K rows and just the two columns (example customer name, color)

[aydeegee]

PM sent

Alastair