I would like to see more information - the first thing is that I would suggest pivoting the last 6 columns of data around the remaining columns - that will allow you to group and aggregate the data
Please attach your workbook in a TWBX format Packaged workbooks: when, why, how
Thank your very much for the reply. So my data set is very very small. It is not complete yet but it will simply include 80-90 companies The 6 columns are about if they have the services or customer segments. I decided to put a 1 for having it and 0 for not having. I didn't do any pivoting because the size is extremely small and task feels easy to me.
Book1.twbx 13.8 KB