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