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.

Research analysis.
 

Hi
looks horrid! Was it extracted from somewhere like a web page? It
might be easier to go back to the original data source and extract it
properly from there. If you can get at the original data source and
present it here, someone may be able to show you how to lift it into
Excel in the right order. If that is not possible, you will need to
present more lines of data as they appear to be intertwined e.g. how
do the the lines above and below the two lines presented relate to
them?

regards
Paul

On Mar 5, 3:58*am, Dan wrote:
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.