select specific cells and place data in other cells excel
I'm looking for a function from which i can select specific cells and place them in the other columns. For example, I have data in the following form:
- Food Processor
- 756
- 890
- Washing Machine
- 290
- 900
- Mixer
- 123
- 893
Now, i want the data in the following form in separate columns:
- Food开发者_StackOverflow中文版 Processor
- Washing Machine
- Mixer
in one column
And the prices in two separate columns.
How do i do that? Thank you!
If you data there was in A1:A9 and you needed every 3rd row in column B then in B1 =OFFSET($A$1,3*(ROW()-1),0) and copy down will give you the 3 records you want from A1,A4,A7 in B1, B2, B3
精彩评论