Is there a way (i thought it would be though dynamic rename, but not sure if this is the right way now) of how you can take the data from the first row of data, and add it into the column heading?
So in the images, I want the first row of plant, to be added onto OpenSO Qty Balance as per the second shot.
To add context, I have 3 input feeds and if something changes I want them to pick up the relevant plant that is there to the output.
Thank you in advance.