converting column of text to text box for repetitive records

  • Thread starter Thread starter bilboda - ExcelForums.com
  • Start date Start date
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
 
Makes no sense whatsoever. Who is Clark? And, what does the fact that he
was happy with a suggestion at another post have to do with this?
 
Sometimes people post under different aliases and sometimes they multipost to
different newsgroups.

Bilboda also posted under Clark Mobley in microsoft.public.excel.
Subject: Re: converting column of text to text box for repetitive records

My response was a warning to others who may read this message that Bilboda/Clark
had a solution and nobody should invest any time on another response.

Here's a link to Clark's other post:
http://groups.google.com/[email protected]
(one line in your browser)

Google will soon scoop up the suggestion with which Clark was happy.


David said:
Makes no sense whatsoever. Who is Clark? And, what does the fact that he
was happy with a suggestion at another post have to do with this?
Click to expand...
 
Back
Top