Change a row of dates to a column

[Camhall]

Hi,

I am trying to change a single row into a column. Please see this example:

This is the input.

Field1	Field2	Field3	Field4	Field5	Field6
Date	6/22/2020	6/23/2020	6/24/2020	6/25/2020	6/26/2020

I would like the output to be like this:

Date
6/22/2020	Field1
6/23/2020	Field2
6/24/2020	Field3
6/25/2020	Field4
6/26/2020	Field5

Can anyone help me with this?

[bpatel · Accepted solution]

hi @Camhall ,

you can use the transpose function. 

hope this helps!