SQLTeam.com | Weblogs | Forums

How to do change the row to column in excel sheet using SSIS


I have excel sheet containing the data like below.

userid username status
usergroup = Admin
admin Admin 1
dav David 1
usergroup = Security_admin
ada Adam 1

I want the data like below,

userid username status usergroup
admin Admin 1 Admin
dav David 1 Admin
ada Adam 1 Security_admin

Is this situation can be handled in SSIS job. Kindly share your thoughts to handle this scenarios.

Thanks in advance

We have to know more about the structure of the spreadsheet in order to solve this. With respect to where the usergroup notations are, are they in a single column, like this?

No Jeff.. The file is like below

I looking for the output as below