> Don't know if this is the easiest but ...
> 1. Add an extra row, at the bottom of the data, containing the numbers 1, 2,
> 3, 4, ... This will be used to remember the original order of the columns.
> 2. Sort the range using options:
> - no headers ("labels") in data
> - sort by columns
> - sort on row 2
> This will put all the "empty" columns after all the non-empty ones
> 3. Select and delete the range of empty columns; this is now easy as the
> empty columns constitute a single range and are thus easily selected: select
> first column, hold down Shift key, select last column.
> 4. Sort the data again using the same options as above but specifying as the
> row to sort by the "numbered" row you added in #1. This puts the non-empty
> columns back in their original order.
> 5. Delete the "numbered" row
>
Harold, that is an ingenious solution! However, there is no guarantee
that row 2 will have data. Actually, there is no single row that will
certainly have data.
I suppose that I could make a new row that totals rows 2-129 and then
sort on _that_, but I'm not certain that it will be _saving_ me work.
Still, I like your thought process and I will certainly adapt that to
problems in the future. Thanks!
--
Dotan Cohen
http://what-is-what.com
http://gibberish.co.il
א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת
ا-ب-ت-ث-ج-ح-خ-د-ذ-ر-ز-س-ش-ص-ض-ط-ظ-ع-غ-ف-ق-ك-ل-م-ن-ه-و-ي
А-Б-В-Г-Д-Е-Ё-Ж-З-И-Й-К-Л-М-Н-О-П-Р-С-Т-У-Ф-Х-Ц-Ч-Ш-Щ-Ъ-Ы-Ь-Э-Ю-Я
а-б-в-г-д-е-ё-ж-з-и-й-к-л-м-н-о-п-р-с-т-у-ф-х-ц-ч-ш-щ-ъ-ы-ь-э-ю-я
ä-ö-ü-ß-Ä-Ö-Ü
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
