Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2016G (64-bit) b9.3.226 Operating System: Windows 10
I have a series of data that came to me stacked (meaning that each column has been multiplied by a factor of 100 successively), and I do not have access to the original data. I need to "undo" this stacking to create a different type of graph (e.g. a 3D Waterfall).
How can I access the column number in a way to make this easier to calculate? I have 6 files with 420 columns each and I really don't want to go column by column on each file...
I assume you want to divide all your columns by 100. If so, you can highlight all your columns, right click and select Set Multiple Columns Values.... In the popped-up dialog, enter wcol(j)/100 in the formula window and click OK. Hope this helps. Thank you.
Using column numbers
Posted - 11/27/2017 : 09:57:07 AM
