Ask Your Question

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

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

lalupa gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

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

lakamha gravatar image
  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

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

Add Answer

Question Tools


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

Seen: 21 times

Last updated: May 11 '22