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

SSIS and Import/Export
1

Hi,

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

2

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?

3

No Jeff.. The file is like below

I looking for the output as below