Multi rows to single row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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