Coverting data in proper format

[deepakqlikview_123]

Managers	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Daryl	12	23	10	9	24	13	19	11	15	21	10	12	179
Thomas	8	10	12	15	18	21	19	16	13	10	8	15	165
Martin	9	12	15	18	21	24	22	20	18	16	14	12	201

Hi All,

Can you please suggest how to convert above data in proper format so that I can create bar chart based on that.

Thanks

[MK_QSL]

Provide me sample data ...

[MK_QSL]

Could be because all null values would be removed..

[deepakqlikview_123]

There are aroung 65000 rows so it was excepting to get 65000

*12 rows, but I am getting around 1,11000 rows.But when I checked table structure after creation of cross table values were assigned properly.(By using Ctrl T).

Is this right or wrong plz suggest.

Thanks

[MK_QSL]

Make sure that your Months (jan, feb, march....) dont have null values...

[deepakqlikview_123]

is there are null values what would have to be done.

[MK_QSL]

Deepak, can you provide me sample data of around 5-10 lines...?

[jyothish8807]

Try using file wizard for creating cross table.It will read all the data within your sheet.

Regards

KC