Attempt to automatically place a blank cell amongst cells or columns or rows

If you already have data in the cells, and you want to move them down/across to create a blank cell...

	A	B	C	D
1	smoke	glow	bush
2
3	becomes
4
5	smoke		glow	bush
6
7	or
8
9	smoke		bush
10		glow

Unless you want to do it manually (Isert cell/move down/right), then youronly option is to use VBA

If you want to create a 2nd table with your data, then we can perhaps do that with formulas

deleted my duplicate post