4

What is the method for putting each value of an array into a separate cell in Excel?

edit

• values
• method
• array

asked 2022-06-05 11:00:00 +0000

lalupa
21 ●1 ●1

edit retag flag offensive close merge delete

add a comment

2

answered 2022-05-11 17:00:00 +0000

lakamha
21 ●3 ●3

1. Select the array of values you want to separate
2. Copy the selected values
3. Right-click on the destination cell where you want to separate the values and select "Paste Special"
4. In the "Paste Special" dialog box, select "Transpose" and click "OK"
5. The values from the original array will be separated into individual cells horizontally in the row. If you want to separate them vertically in a column, then instead of transposing, select the first cell in the first row where you want to paste the values, right-click and select "Paste Special" and select "Transpose" in the "Paste Special" dialog box then click "OK" and the values will be pasted vertically down the column.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss