Duplicate columns dynamically

[SrinivasanSugumaran]

Hi Team,

is there a way we can duplicate the number of columns dynamically.

Input Eg:

Item	col1
Chocolate	30
Food	24
Vegetabls	55

Suppose above is the input i have, then basis the dynamic field i pass the number of columns should be created with the same columns values. i.e if i pass in 2 as my dynamic input parameter, then it should append 2 more columns (col2, col3,) with same values as col. 1

output should be as below 

Item	col1	col2	col3
Chocolate	30	30	30
Food	24	24	24
Vegetabls	55	55	55

Since i need this to be done dynamically for every month (20 cols depending on the working days) which might be eventually considered for year too just thought of seeking your advice.

thank you.

Regards

srinivasan

[binuacs]

@SrinivasanSugumaran one way of doing this

[Qiu · Accepted solution]

@SrinivasanSugumaran 
I hope you accept a Text Input as Dynamic Input 😁

[flying008 · Accepted solution]

Hi, @SrinivasanSugumaran 

Another way without macro for your need:

[SrinivasanSugumaran]

Hi @flying008 , @Qiu, @binuacs ..Thanks much.. :-)

[SrinivasanSugumaran]

Thanks @Qiu . It worked.

[Qiu]

@SrinivasanSugumaran 
Glad to be helpful.