Hi all,

I am trying to design an excel sheet where I can record our B2B survey data. There is categorical data, dates, and numerical data that needs to be recorded. I want to do this in such a way that I can analyze the data efficiently. The problem occurs when I am trying to record multiple products only 1 company purchases from us. Or when we are trying to list multiple "competitors" our customer purchases from as well. Does anyone have any idea as to what the best way to lay out the table might be?

Thanks,

Dave