Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
prabir_c
Partner - Creator
Partner - Creator

Insert blank row after each 3 record

Hello All,

I want to insert 3 blank row after each Data in a Excel.  following is my data-

data.JPG

I want the data as below format.

data2.JPG

This means I have to Copy the full data and  paste it in a excel.  Then Go to last data record and then using a for loop insert a blank row upto A2. Because A1 is the heading.

Please Help. !

11 Replies
Not applicable

Hi Tamil,

Thank you, I am very new to this so I might be doing something wrong or what I am asking for is incorrect.

I have attached what I would like to achieve in excel.Insert Total Row.tif

tamilarasu
Champion
Champion

No problem Clare. Is it possible to attach your application or sample one.? It would be easy for me to help you better. I would suggest you to start a new question.