Converting Rows to Columns

  • Thread starter Thread starter chippette
  • Start date Start date
C

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.
 
Hi,
select the row, copy, go to the column where you want the information, paste
special, transpose
 
sorry I missed something could you please poste a sample on how do you see
your information and what you need to achieve
 
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
 
Back
Top