Insert spaces between pasted values

M

m m

Hi!
Is there a way to insert spaces between values that are pasted? For example, i have in rows 1,2,3 values a,b,c and i want to paste them into another list in rows 1,3,5 respectively (with a single-row space between pasted values).
Thanx!
M
 
P

Pete_UK

I presume you have more than just 3 rows. A general approach would be
to use a helper column next to your data and to fill a simple sequence
down that column for as much data as you have. Then copy all the
numbers that make up that sequence and paste them immediately below
the sequence in the same column, so that if you have 200 numbers for
example then you will have the sequence 1, 2,3,...200,1,2,3,...200.

Then you can sort both columns of data using the helper column as the
sort field and the other column as the secondary sort field, and then
you can delete the helper column.

Hope this helps.

Pete
 
Z

Zaidy036

Hi!
Is there a way to insert spaces between values that are pasted? For example, i have in rows 1,2,3 values a,b,c and i want to paste them into another list in rows 1,3,5 respectively (with a single-row space between pasted values).
Thanx!
M
free ASAP Utilities has a function to add empty rows or columns.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top