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?
|