How to paste values from one range into another?

Question

I have a very poorly formatted data set where date is presented as a row instead of a column:

Basically, I want to cut and paste all the values from row 2 into row 1, starting with "Field_6". The data set is updated daily, so I need the range to start at column 2 but continue on indefinitely, see current end of the range:

EDIT: added input sample file

EDIT 2: added "desired output" sample file

all.csv

all - desired output.csv

Emmanuel_G · Answer

Hi @armkraftiga ,

See attached one way to achieve this easily.

Paste values from one range.yxmd

armkraftiga · Answer

Appreciate the reply; unfortunately that does not seem to work for me because I need the dates to be recognized as headers for when I use the Transpose tool; otherwise the numbers that appear in the rows below (scroll all the way to the right in the input file) will end up in the same column as the dates.

I will add an output example file to show what I'm trying to get Designer to do.

michelle_mathews · Answer

Hi @armkraftiga , I'm not sure I fully understand but sounds like you could accomplish this with the Select Records tool to separate out your date row from the rest of your data. Then you could use a Union to re-append the data in whatever manner you wish (choose option 'Manually Configure Fields' if you need to position the data in a specific way)