开发者

select specific cells and place data in other cells excel

开发者 https://www.devze.com 2023-04-07 04:21 出处:网络
I\'m looking for a function from which i can select specific cells and place them in the other columns.

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号