Converting Rows to Columns

[chippette]

Hi,

I have a report that prints with the same information on several rows. Let
me explain.

I have a heading row the includes the following.
Name, SSN, Salary, Date of Hire, Address and Benefits.
Since there are several benefits, the report makes a new row for each
benefit so each employee could show up with as many as 8 rows of the same
information except for the benefit.

I need to get one row that has all of the information with the benefits
listed as their own seperate column.

 

[Eduardo]

Hi,
select the row, copy, go to the column where you want the information, paste
special, transpose

 

[chippette]

what happens to all of the other duplicate information?

 

[Eduardo]

sorry I missed something could you please poste a sample on how do you see
your information and what you need to achieve

 

[Ashish Mathur]

Hi,

Is benefit a numeric column I.e. does this solumn contain the quantum of
benefit or is is a text column I.e. benefit type such as "car allowance"

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com