Home > Answers > What formula can I use in Excel 2007 to create one list twa1310542573
What formula can I use in Excel 2007 to create one list from another?
Please see the image for a visual representation of this. The left-hand list contains the information I want, at regular intervals of 3 rows. I want to copy only this information into a list on the right, which would no longer be separated by rows.
I've already tried 2 things: in C1, C2 and C3 putting =A1, =A4 and =A7, but when I highlight and pull down to copy the formula, the formula doesn't continue upwards (i.e. A10, A13 etc.) so the results are inaccurate.
I've also tried =A3, =A(3+5), but it doesn't like the brackets at all.
Although the question is quite complex, what I am asking is actually very simple.
Does anyone have a solution?
- Ngành nghề/Lĩnh vực: Software
- Category: Productivity software
- Created: 02:36, 13 July 2011
Người tạo
Featured blossaries
Silentchapel
0
Terms
95
Bảng chú giải
10
Followers
Famous Volcanoes
Chuyên mục: Geography 1 20 Terms
SharfuddinR
0
Terms
11
Bảng chú giải
2
Followers
Corporate Social Responsibility CSR
Chuyên mục: Business 2 11 Terms
dnatalia
0
Terms
60
Bảng chú giải
2
Followers
Herbs and Spices in Indonesian Cuisine
Chuyên mục: Food 1 10 Terms
Marouane937
0
Terms
58
Bảng chú giải
3
Followers
The World's Highest-Paid DJs 2013
Chuyên mục: Entertainment 3 10 Terms
tim.zhaotianqi
0
Terms
40
Bảng chú giải
4
Followers
Top Venture Capital Firms
Chuyên mục: Business 1 5 Terms