How do I fill (copy) nonadjacent cells to adjacent cells?

G

Guest

I have data that is 22 cells apart which are related which has data between
them which are 22 cells apart also, i.e. 1's are related, 2's are related
data, etc.
I have currently:
1
2
3
1
2
3
1
2
3
I want:
1
1
1
2
2
2
3
3
3
etc.

Thanks
 
G

Guest

Here's the quick and easy on this one.

Select your top row that labels your data and then turn on the auto filter
feature

Data --> Filter --> Auto Filter.

You'll then see a drop down on the row above your first column. Click on it
and you'll see you can sort ascending/descending.

This should put all your data in the format you want.

-Jacob F. Roecker
 

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