[TABLE="class: grid, width: 300, align: center"]
<tbody>[TR]
[TD]Expense[/TD]
[TD]Food[/TD]
[TD]drinks[/TD]
[/TR]
[TR]
[TD]1. Food[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Bread[/TD]
[TD]Bread[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Rice[/TD]
[TD]Rice[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Drink[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Water[/TD]
[TD][/TD]
[TD]Water[/TD]
[/TR]
[TR]
[TD]2 drink[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Juice[/TD]
[TD][/TD]
[TD]Juice[/TD]
[/TR]
[TR]
[TD] Food[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Pasta[/TD]
[TD]Pasta[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3 foOd[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Meat[/TD]
[TD]Meat[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Drinks[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Coffee[/TD]
[TD][/TD]
[TD]Coffee[/TD]
[/TR]
</tbody>[/TABLE]
HI,
I hope you could help. i have 1 column and it has 2 categories (eg: food and drinks). I have to separate them into 2 columns and extract only the items below it(rows after it) And be paste into the cell right next to it. See sample above.
If using formula will do instead of macro its ok.. im still a newbie though.
Kindly help. Thank
<tbody>[TR]
[TD]Expense[/TD]
[TD]Food[/TD]
[TD]drinks[/TD]
[/TR]
[TR]
[TD]1. Food[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Bread[/TD]
[TD]Bread[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Rice[/TD]
[TD]Rice[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Drink[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Water[/TD]
[TD][/TD]
[TD]Water[/TD]
[/TR]
[TR]
[TD]2 drink[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Juice[/TD]
[TD][/TD]
[TD]Juice[/TD]
[/TR]
[TR]
[TD] Food[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Pasta[/TD]
[TD]Pasta[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3 foOd[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Meat[/TD]
[TD]Meat[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Drinks[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Coffee[/TD]
[TD][/TD]
[TD]Coffee[/TD]
[/TR]
</tbody>[/TABLE]
HI,
I hope you could help. i have 1 column and it has 2 categories (eg: food and drinks). I have to separate them into 2 columns and extract only the items below it(rows after it) And be paste into the cell right next to it. See sample above.
If using formula will do instead of macro its ok.. im still a newbie though.
Kindly help. Thank