Answered

Copy from Excel and paste horizontally

(0) Share

Report

Posted on by dashort

Hi folks. I'm looking reformat an Excel spreadsheet to basically group items in a horizontal entry instead of vertical.

I have a list of entries in a column, about 10 of them which describe a person. Name, address, etc. The data is produced through a SQL query and stored in Excel.

I would like to reformat the data to have 10 columns of data, with each row containing the person's information.

As I understand it, I need to copy a range of cells and then write them to another worksheet. What I can't do is have them written horizontally, instead of vertically.

Your help is greatly appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

Copy

in new tab

right click -> Paste Special -> Transpose -> Ok

If you still need to automate it, you should be able to use hot keys to do paste special transpose. I think {Menu} is the right click button in send keys and then hover your mouse over the transpose symbol to see what the hotkey is.

best of luck.

Was this reply helpful? Yes No
CKN 58 on at

Like (1)

Report
Copy link

Link copied!

you could try something like this

The datatable created is a 10x10

Was this reply helpful? Yes No
dashort 62 on at

Like (0)

Report
Copy link

Link copied!

CKN thanks so much. Is there a way for me to iterate through the entire resultset using this approach? ie. additional records...

Was this reply helpful? Yes No
Verified answer

CKN 58 on at

Like (1)

Report
Copy link

Link copied!

Set the datatable up as a 1 row, 10 columns
Adjust the excel range from a1:j10 to a1:z10 (or some other column to finish that is outside the range of input data)
Adjust the loop 0 to 9 to be 0 to (number of columns input)-1. It was 9 which is a:j (10 columns) -1
If input is a1:z10, loop is 0 to 25 like this

Was this reply helpful? Yes No
dashort 62 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for taking the time to assist. You're the best!

Was this reply helpful? Yes No