Total columns

Hi,I hve 26 spreadsheets in a file.each sheet has a different name.When these files are ready they dump the data in a Oracle database in one table.I am facing one issue i.e when they dump the data suppose column b name is scrap and in scrap column
there are different rows and their is one row called newspaper and newspaper has 12 row or more than, I want to know in newspaper row it dump the data in how many columns.


This is something oracle should give or if there are rules you can use rules to identify the rows