nirisan
asked on
SQL statement to convert data from rows to columns from a spreadsheet in required format
Hi
I have a spreadsheet where I have to convert a column into rows with header and add 1 or 0 if data is present or not, as the row values.
Samples attached.
Can I do this by importing the spreadsheet into a SQL database and write a select statement? If so can the sql statement be provided?
so for one pair of origin and destination will have all the applicable days as 1 or 0 in one row.
original1.xls required-format.xls
I have a spreadsheet where I have to convert a column into rows with header and add 1 or 0 if data is present or not, as the row values.
Samples attached.
Can I do this by importing the spreadsheet into a SQL database and write a select statement? If so can the sql statement be provided?
so for one pair of origin and destination will have all the applicable days as 1 or 0 in one row.
original1.xls required-format.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER