Iterative Macro : appending new column every iterations

[pchong]

Hi Community!

I'm looking to iterate a simple input of numbers and iterate multiple times and append each result as a new column every iteration.

In this example, I want to multiply the original number by 2 every iteration.
Sample input :

Original	Number
1	1
2	2
3	3
4	4
5	5

Desired result (dynamically rename result columns) :

Original	Number	Num1	Num2	Num3	Num4	Num5
1	1	2	4	8	16	32
2	2	4	8	16	32	64
3	3	6	12	24	48	96
4	4	8	16	32	64	128
5	5	10	20	40	80	160
6	6	12	24	48	96	192

I couldn't get the macro to work, and hope I can get some help here!
In my sample workflow here, I only want it to iterate 5 times.

Any help is appreciated, thanks!

[Raj]

./

[pchong]

Hi Raj,

Unfortunately the video is not helpful.

I understand that piece of iterative macro, but it's a simpler one because it doesn't append the result each iteration.

It only output one single output and that's easier to implement.

[Raj · Accepted solution]

@pchong 
find the workflow attached, Marco is tweaked a bit


mark done if solved.

[CoG · Accepted solution]

Adding columns dynamically is not a very simple procedure, but it can be done. I rebuilt your macro to accomplish the stated objective. Hopefully this is a valuable learning tool for you for: Iterative Macros, Dynamic Replace Tool, & Dynamic Rename Tool

Happy Solving!

[pchong]

Thanks Raj! 

I was hoping the macro can do all the cross tab and so on, but this works as well!

[pchong]

Thanks Andrew!

Dynamic Replace is new to me and it's very useful!