Copy numbers of cell values in a single row

Closed
Ishi - 16 Jul 2009 à 04:35
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 17 Jul 2009 à 00:42
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 response

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
17 Jul 2009 à 00:42
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