Create multiple new columns from one column

[farhana_91]

Hi All

I have a column : 2018-01-01

Retailer Name	2018-01-01
Retailer 1	10
Retailer 2	11
Retailer 3	12
Retailer 4	13
Retailer 5	14
Retailer 6	15
Retailer 7	16
Retailer 8	17
Retailer 9	18
Retailer 10	19

Now I am trying to create muliple columns based on the values * by 2

Retailer Name	2018-01-01	2018-01-02	2018-01-03	2018-01-04	2018-01-05	2018-01-06	2018-01-07	2018-01-08
Retailer 1	10	20	40	80	160	320	640	1280
Retailer 2	11	22	44	88	176	352	704	1408
Retailer 3	12	24	48	96	192	384	768	1536
Retailer 4	13	26	52	104	208	416	832	1664
Retailer 5	14	28	56	112	224	448	896	1792
Retailer 6	15	30	60	120	240	480	960	1920
Retailer 7	16	32	64	128	256	512	1024	2048
Retailer 8	17	34	68	136	272	544	1088	2176
Retailer 9	18	36	72	144	288	576	1152	2304
Retailer 10	19	38	76	152	304	608	1216	2432

Please guide.

Thanks in Advance.

[ponraj · Accepted solution]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults

[yalmar_m · Accepted solution]

Dear @farhana_91,

Did you think about transposing the data and generating rows?

I added an example where you are able to determine your personal MaxDate.

Best,

Yalmar

[farhana_91]

Thanks Yalmar!

My data was much suited for the other workflow. However,this was a good solution as well.