B
bilboda - ExcelForums.com
Hi,
I have a spreadsheet which contains employee information including
job
skills. My problem is that each skill (cook,candlemaker, etc.)creates
a new
row for that employee, duplicating fields that don't change, name,
ss#,etc
with the only new info in the row being the skill
Like this:
Jane doe,123456789,555-555-5555,cook
Jane doe,123456789,555-555-5555,candlemaker
What I want is 1 row for each employee with the last column containing
all
the skills in a text box or separated by commas. Is there an easy way
to do
this in Excel? Or even Access?
To clarify, I want to convert all skills listed in the skill column
for each
employee to one cell in that row:
|Jane doe |123456789 | 555-555-5555 | candlemaker, cook |
Thanks
I have a spreadsheet which contains employee information including
job
skills. My problem is that each skill (cook,candlemaker, etc.)creates
a new
row for that employee, duplicating fields that don't change, name,
ss#,etc
with the only new info in the row being the skill
Like this:
Jane doe,123456789,555-555-5555,cook
Jane doe,123456789,555-555-5555,candlemaker
What I want is 1 row for each employee with the last column containing
all
the skills in a text box or separated by commas. Is there an easy way
to do
this in Excel? Or even Access?
To clarify, I want to convert all skills listed in the skill column
for each
employee to one cell in that row:
|Jane doe |123456789 | 555-555-5555 | candlemaker, cook |
Thanks