I have an excel sheet with 3 columns
a. Application Name
b. Group Name
c. User Name
I want to import the excel sheet into sqlserver. My problem is that excel sheet contains toggled column. i. e Application name is my parent group(root level ) and Group Name name is my child group and User name is child of Group Name group. When am trying to import to sql tables , the grouping columns having null values. Only one column contains data.
I have attached the sample format of my excel sheet with this mail.