How to space column data with a fixed amount of spaces

Help Studio
, ,
1

Dear UiPathers

I have the following Excel document
image

Which is saved in a datatable, named dt_1.

How is it possible to space that datatable such that I get something that resembles the following
image

With other words, is it possible to space my datatable, dt_1 such that I can save it in another datatable called dt_2 which has the values of dt_1 and spaces between the columns? I need the datatable to have columns since I need to place the datatable in a new Excel file where the placement of the values is important.

Hope to hear from you guys, and have agreat day/ night forward!

Yours sincerely…
Jumanji

2

Hello @nmjvk you can use insert column activity

3

That’s not space between the columns. That’s blank columns. Just create two new columns in your datatable, leaving them empty.

4

Hello. “Space” and “blank columns” would for most people, including myself, be the same, the difference is purely acoustical

5

Dear Ankit

Do I have to use Insert Column activity on my dt_1 and give it blank columns?