function Making one row out of many
in [General]
|
Prev: Conditional format Formula -Duplicate & n/a
Next: Excel 2007 - Rows - Height - AutoSize question
From: dersonnenach on 30 Mar 2010 11:31 I have 72 rows, each one is about 10 cells long. Does someone know a function to make one row out of this? Thanks a lot! Melanie
From: Jim Cone on 30 Mar 2010 12:31 That would convert to ~720 columns and therefore requires xl2007. If your data start in cell A2... 1. In B2 enter =A2&" " &B1 2. Fill down 3. Copy and paste values over the bottom cell in column B 4. Use Text to Columns in that cell. 5. Sort the resulting row in ascending order. -- Jim Cone Portland, Oregon USA (30 + ways to sort... http://www.contextures.com/excel-sort-addin.html) "dersonnenach" <dersonnenach(a)discussions.microsoft.com> wrote in message news:68DD6F4E-34FC-4D21-B061-20CA010AB544(a)microsoft.com... I have 72 rows, each one is about 10 cells long. Does someone know a function to make one row out of this? Thanks a lot! Melanie
From: Jim Cone on 30 Mar 2010 12:40 Actually, what I posted will only work for a single column. You should be able to alter it to work for ten columns. Jim Cone "Jim Cone" <james.coneXXX(a)comcast.netXXX> wrote in message news:OKhC9ZC0KHA.4656(a)TK2MSFTNGP05.phx.gbl... That would convert to ~720 columns and therefore requires xl2007. If your data start in cell A2... 1. In B2 enter =A2&" " &B1 2. Fill down 3. Copy and paste values over the bottom cell in column B 4. Use Text to Columns in that cell. 5. Sort the resulting row in ascending order. -- Jim Cone Portland, Oregon USA (30 + ways to sort... http://www.contextures.com/excel-sort-addin.html)
|
Pages: 1 Prev: Conditional format Formula -Duplicate & n/a Next: Excel 2007 - Rows - Height - AutoSize question |