I am trying to find a quick way to convert an Excel 2013 spreadsheet to a database table. I am familiar with the Transpose feature in Excel - but I don't think this is what I'm looking for. My challenge is the top row really needs to be one of the fields in the database table. The database table structure is three fields - CustomerId / ItemId / Price - the spreadsheet that was given to me has the Top Row as the ItemId:



See attachment . . . .

What I need is:

CustId ItemId Price
ABC01 ITEM01 102.30
ABC01 ITEM02 77.50
ABC01 ITEM03 14.77
FRK03 ITEM01 110.33
FRK03 ITEM02 66.33
FRK03 ITEM03 14.77

The spreadsheet I'm working with has 278 rows and 55 columns worth of data.

Thanks in advance,

MB

Attached Files

cEx.xlsx (8.9 KB, 18 views)