pycoh
03-05-2015, 01:55 PM
I have a very big csv file approx 800 columns and 6500 rows sometimes even more.
1st. since this is a huge file, i need a macro deleting blank columns. row 1 has a label on it. so i want to delete that as well, only if there are no values on that row.
2nd. i need to delete blank rows as well.
can this be activated individually? because i want to check the datas first after deleting the blank columns?
hope someone can help me out on this.
Thanx in advance!
1st. since this is a huge file, i need a macro deleting blank columns. row 1 has a label on it. so i want to delete that as well, only if there are no values on that row.
2nd. i need to delete blank rows as well.
can this be activated individually? because i want to check the datas first after deleting the blank columns?
hope someone can help me out on this.
Thanx in advance!