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.


--
God bless.

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

"chippette" wrote:

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.


--
God bless.

what happens to all of the other duplicate information?
--
God bless.


"Eduardo" wrote:

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

"chippette" wrote:

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.


--
God bless.

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

"chippette" wrote:

what happens to all of the other duplicate information?
--
God bless.


"Eduardo" wrote:

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

"chippette" wrote:

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.


--
God bless.

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

"chippette" wrote in message
...
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.


--
God bless.