Creating a Complicated Table

Hello All

I would like to make a table to compare between the following:

3 telecom operators: Operator 1, Operator2 and Operator 3

In terms of the following: Customer Satisfaction, Market Share, NPS and Customer Base.

In 3 cities: Cairo, Alexandria, Giza

How can I design a table including all of these data?

Note: the customer staisfaction includes the following: coverage, quality of netoworks, easiness.

oooh, I am sorry. I expected that what I mentioed made my query clear enough.

Let me give you more details about what I watned to do.

I would like to make a comparison between 3 operator inn terms of the following: Customer Satisfaction, Market Share, NPS and Customer Base. I can make a table regarding this input. As in the column I can mentionn the name of the operator, and in the cell I can put the critera (NPS, Customer base and etc.). The table will be filled by the output of the market survyies.

What makes it too difficult to me is to make a comparison in 3 cities. So now where can I add the cities in the table.

What make it more difficult is that one of the categories which is (Customer Staisfaction) in cludes 3 variables. so that is why I consider it too much complicated.

Hope that helps you understand what I am looking for.

Thanks in advance for your support.

The attached file includes the inputs that I wanted to put in the table. Noting that I wanted to make the 3 table in one table.

Compliacted Table.xlsx

I am waiting for your answers.

Thank you so much Debraj

I really don't know how it can be done. It made me confuse when I found that the name of the operator doesnt' mention in the sheets mentioned in the ranges part. The first column address is Customer Satisfaction which is repeated twice in the same sheets. Did you mean the first column address to be ( opeartor)?

I also appreciate if you can let me the name of what you did and if you can recommend any vidoes on Youtube reagarding it to learn how can I do that.

It doesnt make sense to me, in your file example, is that what you after or your data?

I have closed it. I made its status to be (resolved)