Paste List data to Excel columns

Iqkh76

December 03, 2019 17:23

Trying to paste the list column value to Excel columns however the list is added to the rows instead of columns. I tried defining the column range but still it pastes to rows.

Comments

6 comments

James Brammer December 03, 2019 17:26 (Edited December 03, 2019 17:41)

I think you have to loop down the column for that. Otherwise you could excel's Paste Special > Transpose to swap a copied set of Rows -> Columns, or go from Columns -> Rows.

0

Comment actions Permalink
Mathias Balsløw December 03, 2019 17:33

Hi!

I'm not quite sure I understand what you are trying to do. Do you have the data in a Foxtrot list and wish to only write the names of the columns of the list?

0

Comment actions Permalink
Iqkh76 December 03, 2019 17:40

Thanks James, I will try it and let you know.

Mathais, I need to paste the data in a column in the list to columns in Excel. For E.g. I have 243 rows of records and I need to paste those the records in coljumn H6 to IS6 of Excel file.

Thank you

0

Comment actions Permalink
Mathias Balsløw December 03, 2019 17:46

Do you have the data in your clipboard or in a Foxtrot list?

If you have it in your clipboard, you should be able to simply target cell H6 and use the "Paste Cell" record. Did you try this?

0

Comment actions Permalink
Iqkh76 December 03, 2019 17:54

The data is in List and when I try to paste the date to H6 it paste the data to rows and not the columns.

0

Comment actions Permalink
Mathias Balsløw December 03, 2019 17:59

Okay, I would then either attempt James's solution or simply construct a loop where you loop through each column and row to send the values to the specific cells you desire using the "Send Value" action. You can use variable to manage what column and row you target, and you can use the list lookup to grab the data from the list.

I hope this makes sense.

0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?