Copy numbers of cell values in a single row

Closed
Ishi - Jul 16, 2009 at 04:35 AM
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
- Jul 17, 2009 at 12:42 AM
Hello,

I have unit numbers in multiple rows which is captured from a pivot table from another sheet. I need to consolidate all the cell values from all the rows to one row as a running text.

Can someone help please.

1 reply

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 17, 2009 at 12:42 AM
Hello Ishi

if you hve data in A1, A2 etc then add the following formula in B2 =B1+A1 In the last cell you will get the desired value
1