Add Rows in between the existing data rows.

Question

Hi Guys,

I am working on a data that has more that 10,000 rows, that requires me to add a blank row in between the data sets that I have. Can someone guide me on this.

Example:-

My input is.

A100B200C300D400E500F600G700H800

Output required

A100  B200  C300  D400  E500  F600  G700  H800

demand_james · Accepted Answer

Here is a simple way.

Put in a record ID field -  then create one stream with only the record ID.    Union it back to the original,  sort, then remove the record ID with the select.

You might need to watch the output order on the union to get the blanks before or after.

DiegoParker · Accepted Answer

Hi RajayKumar,

My approach would be the following: I would use the generate rows tool.

Please find the workbook attached.

Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego