Multi rows to single row
 

I have a spreadsheet with multiple rows and want to take info from it to a
new sheet in single rows.
Eg.
Company Name
Sale A $100
Sale B $200
Sale C $300
Total $600
to a new sheet that shows
Comany Name Total
What type of formula do I need?

Multi rows to single row
 

Assuming the sets are all five rows in Column A of Sheet1 enter this in A1 of
Sheet2

=INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*5+COLUMNS($A:B)-1)

Copy across to E1.

Select A1:E1 and copy down until you get 0's showing up.


Gord Dibben MS Excel MVP

On Thu, 25 Jan 2007 13:50:00 -0800, jostlund
wrote:

I have a spreadsheet with multiple rows and want to take info from it to a
new sheet in single rows.
Eg.
Company Name
Sale A $100
Sale B $200
Sale C $300
Total $600
to a new sheet that shows
Comany Name Total
What type of formula do I need?