Data in columns convert to single line

P

PAR

A spreadsheet exports like this for a huge population of employees' benefit
elections:

EE# BEN TYPE BEN PLAN $per EE $ per company ANNUL SAL COV AMT
1 MED MEDA $1500 $3000
$50000
1 DEN DEN1 $200 $400
$50000
1 VIS VISA $150 $300
$50000
1 LIFE METLIFE $6.45 $0
$50000 $100000

NEEDS TO LOOK LIKE THIS (ALL ON ONE LINE PER EE) :
MED EE MED CO DEN EE DEN CO VIS EE VIS CO LIFE ANNUAL
SAL
1 $1500 $3000 $200 $400 $150 $300 $6.45
$50000

Additional demographic information need also be included similar to annual
salary where the info on the raw data sheet is exactly the same for each row.
There are multiple plan names for each benefit type and the plan name needs
to be noted on the singular line per employee as well. Can this be done? I
tried to use lookup and match, but had trouble because there are multiple
rows per employee id so did not get desired results.
 
P

PAR

Additional information - the # of lines per ee# varies each time the report
is produced.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top