Conditional Additions

[KansasLane]

I'm new here.
I am wondering if anyone knows how to add and option in a column to add another column.
For example, I want to record what chemicals I am applying, and since sometimes there may be up to 7 chemicals at a time, I want the option to record each one, or if there are fewer (obviously no less than one), I want the option to have just one column. I want to be able to enter information in one column, as well as have the option to add another column in case I am applying another product. This will have to be more complicated than formatting because I intend to lock the features and share it with my employees so that they can document what all they do as they do it.
Hopefully I did not explain this in a confusing way. Any help is appreciated!

 

[oldbrewer]

in excel you have hundreds of columns of course. If A1 = copper sulphate that is all you see if B1 = nitric acid you see both

you could see if you wanted copper sulphate - deliberately empty - deliberately empty - deliberately empty - deliberately empty - deliberately empty

 

[sandy666]

is that what you want?

col1	col2	col3	col4		Column1
aa		abc	12a		aa
	123​		23b		bb
bb	234​		aa		123​
123​	567​	def	34g		23b
		ghk			234​
23b					567​
					abc
					def
					ghk
					12a
					34g