SQLSearcher
asked on
Excel row and column as one record
Hello Experts Exchange
I have a spreadsheet that has a table of data, the has product information going down the left of the row and date information going across the top.
Is it possible to get the product information and the date information in one row in Excel, so I can import the records into SQL Server?
I have attached how the data is on sheet1 and on sheet2 I have added a example of how I want the data.
Regards
SQLSearcher
Losses-Example.xls
I have a spreadsheet that has a table of data, the has product information going down the left of the row and date information going across the top.
Is it possible to get the product information and the date information in one row in Excel, so I can import the records into SQL Server?
I have attached how the data is on sheet1 and on sheet2 I have added a example of how I want the data.
Regards
SQLSearcher
Losses-Example.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.