Hi
Greetings of the day.Sorry if my question is foolish as I don't know of Excel functions except a few basics.
I have a spreadsheet converted from pdf having more than 30 Columns .for Example( name, address, tel. website , products etc).
Problem is that data is not consistent in all columns.Some have full range(all 30+ columns having data) and in some not( only some columns having data )
I want to organize data as per headers and leave cell blanks or fill in (N/A) where data is not available for that field. How can I correctly populate it.I need data as per headers in rows.
Here i am dealing with 2k rows with 30+ columns.
Please walk me through with it.
All replies will be appreciated with examples.
Sorry if i have broken any of the Forum's rule. MODS Please correct me if i am wrong.
Thanks.
Bookmarks