How can I "transpose" multiple columns into one column with multiple rows?

klangridge103846

I am looking to convert multiple columns of data into a row per column populated. A bit like "transpose"

So as follows:

Automation doesn't seem to give me the flexibility to be able to do this.

Any ideas?

Thanks in advance

=Chris Palmer

Hello @klangridge103846

I've had a similar scenario as yours, and was able to quickly achieve this in two steps:

Step 1: Export the Smartsheet into Excel
Step 2: Copy the first row from Excel into the desired row inside your Smartsheet