blank column after every column which have data

[mayankagruce]

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.

[grazitti_sapna]

@mayankagruce, give this workflow a try.

The names for the blank columns might change as they are replicating for each column that is filled.

I hope this helps!

Thanks!

[Qiu · Accepted solution]

@mayankagruce 

If I understand your intention correctly.

[mayankagruce]

Thank you for the quick response. I was able what i wanted except checking the blank columns. which is found in next solution.

[mayankagruce]

Thank you for the quick response. This was really helpful.