In excel sheet I have to add 4 pre-defined columns ( cell_type, cell_uuid, parent-1 and parent-2) which are blank columns actually, after every column which have any data value in there. so basically have to first check every column for any value in that and if yes, then add these 4 columns after that.
i have multiple files like this so once logic is clear for above problem i need to create batch macro later to process multiple files at once.
