Revision history [back]

Select the array of values you want to separate
Copy the selected values
Right-click on the destination cell where you want to separate the values and select "Paste Special"
In the "Paste Special" dialog box, select "Transpose" and click "OK"
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.