Formula help

[mj22]

I have an excel spread sheet similar to the example pic uploaded.

User info is stored in rows, there is a single entry for each user. The skills each user has are listed in a single column.

Im hoping someone can help - I need to get the skills for each user into individual cells in the row where their user info is.

I then need to sort, the skills so each skill will appear in the same column ie.

A. B. C. D. E. F
Username, staff info, FTE, skill1, skill3
Username, staff info, FTE, skill1, skill2, ,skill4
Username, staff info, FTE, skill1, ,

Nothing I've tried seems to be working.


Thanks all!!

 

[SanjayGMusafir]

How many total staff people you have? If it's not much -

Sort Skills Individually for each staff and then Copy Paste Using Transpose

With Excel 2013 in your hand, I can only think of that. Still it shall all depend on the quantum of whole exercise.

 

[mj22]

How many total staff people you have? If it's not much -

Sort Individually for each staff and then Copy Paste Using Transpose

With Excel 2013 in your hand, I can only think of that. Still it shall all depend on the quantum of whole exercise.

Thanks, I'm not sure how easy that will be as there's about 1300 staff to do it for

 

[SanjayGMusafir]

I'm not sure how easy that will be as there's about 1300 staff to do it for

Undoubtedly not easy with that much data.

Probably I remember some video on youtube by Excel Campus Jon or Chandoo who partially addressed this situation.

I shall share that link if found. Else hope the thread catches eye of someone who knows a better solution for you...

 

[mj22]

I have an excel spread sheet similar to the example pic uploaded.

User info is stored in rows, there is a single entry for each user. The skills each user has are listed in a single column.

Im hoping someone can help - I need to get the skills for each user into individual cells in the row where their user info is.

I then need to sort, the skills so each skill will appear in the same column ie.

A. B. C. D. E. F
Username, staff info, FTE, skill1, skill3
Username, staff info, FTE, skill1, skill2, ,skill4
Username, staff info, FTE, skill1, ,

Nothing I've tried seems to be working.


Thanks all!!

Additional info. Roughly how it needs to look in image

There is 1300 staff and approximately 80 different skills

 

[SanjayGMusafir]

Additional info. Roughly how it needs to look in image

There is 1300 staff and approximately 80 different skills

I suppose it's all together a different situation now... Probably solvable if approached differently...

Share an XL2BB of sample data to give a starting point to work on.

Also any other condition should be clarified now...