View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan[_51_] Dan[_51_] is offline
external usenet poster
 
Posts: 3
Default Research analysis.

Help...
I am posting thread second time...
I have an Excel file with Languages and Numbers of speak 'em in India/Nepal
dialects and other languages. The table is a mess - I need to sort the data
according to Place, organize the way 1 language is set only in 1 column and
figure in next. As an example, here is a portion of what it looks like...

BairgiyaBanchauri Total 6568 Maithili 6453 Maithili 1687 Nepali 13
BairgiyaLaxminiya Total 3259 Others 102 Nepali 100 Others 1496

and I need to have it this way...

BairgiyaBanchauri Total 6568 Maithili 6453 Others 102 Nepali 13
BairgiyaLaxminiya Total 3259 Maithili 1687 Others 1496 Nepali 100

I can not use Pivot Table as the data is not organized accordingly -- I
would appreciate any help with. This is just a portion of it - the table is
huge and I need to sort it.

Dan.