How to paste values from one range into another?

[armkraftiga]

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

[dinesha]

please post data set

regards

dinesha

[michelle_mathews]

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)

[armkraftiga]

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.

[Emmanuel_G]

Hi @armkraftiga ,

See attached one way to achieve this easily.