Can Google Sheets handle 3D data?
Wondering if a cell can reference data from a range of other cells in another sheet? For example, if you have the following columns:
Business name | City | Employees
cell B1 | cell B2 | cell B3
I'm not talking about a lookup table like Excel where "Employees" grabs one value from another range of cells. I'm asking if Sheets can, for cell B3 for instance, contain the entire list of employees for the business at B1?
Can you share sample rows/data to better understand the problem? Do you want something like this?
If yes, you will also need to let me know how you want to identify people outside names.
Thanks for answering @ravivyas
The example is just that, an example, my actual data is far more complex and wouldn't make sense so I created a simple example.
So I see what you are suggesting. The answer is yes and no, that's showing all the data, yes. But I don't want to see Microsoft | Singapore listed more than once. I want the employees cell to be, for example, a pull-down where when I click a down-arrow it shows me a list of all the employee names in the one cell, C4.