Inserting empty columns

[calvincarr29]

I need to insert a blank column between each state. Is there a way to do this?

[brolin · Accepted solution]

Hi @calvincarr29 , I hope the attached helps? The idea is to convert the columns to rows using Transpose, rename them, union with the original Transposed output and then Cross tab them back to columns. 

Let me know if you have any questions on this or if it solved your problem.

[flying008 · Accepted solution]

Hi, @calvincarr29 

There is a workaround of Generate Rows for you: 

[brolin]

Hi @calvincarr29 , did the above responses help answer your question? If so, please can you mark one as an accepted solution to help others quickly identify the solution when they have a similar problem? Thanks!

[calvincarr29]

Hi @brolin thank you so much. My apologies for the late reply.

[calvincarr29]

Hi @flying008 thank you as well for this solution. You introduced me to tools that I haven't used before. I really appreciate it.