Is there a method to import different data in one cell?

[tesoke]

Hi, I have a problem and mention it via an example:

For example, I want to import information of some goods in an excel file similar the attached picture. I imported the numbers of goods which every person repair in days of month, but I need to import another information too. For example I should know when Max has repaired 5 goods in first of month, what kind of goods? How much his salary in first day? What is the percentage of his repairing? I do not want to import this information in another columns because that the number of people is high and I do not want to have a excel file with many many columns.

I think that it is possible that there be some methods to import different data in one cell. For example, using an array. What do you think? Is there a method or I am obligated to import different data in different cells?

[Pecoflyer]

It would not be wise to group lots of different information in one cell as this would make later analysis very difficult

To limit the number of columns you could use columns like

Date - Name - Daily Qty and perhaps some others

not one column per person

Then, with proper formulas- Pivot Tables or other means, you can extract the information you need quite easily if your columns are well thought.

First think about what you will need in the end, then think about the way to obtain it

[tesoke]

Yes, but the problem is that if I add different columns, it leads to increase in the number of columns. So, I cannot see all data in screen and have to move left and right. I need to see all data in screen to decide based on them.

[tesoke]

I will appreciate if you propose an idea.

[Pecoflyer]

Again, 4 to 10 columns would probably be the max, which fits perfectly on a screen.

You DO NOT need 1 column per person

[tesoke]

I could not understand! Rows are related to date and columns to, you say, salary and quality and number of repairments. So, what about the person's name? How can I understand which number is related to what person?

[Pecoflyer]

Like this ?

This can now be analyzed depending on what you want

Data can be entered with a simple entry form if needed

[tesoke]

Thank you, but it cannot solve my problem. Because your proposed method increases the number of row, which is not proper. Increasing row leads me to cannot see the whole data in screen too. Another idea? I think I have to use array or similar something. What do you think? Thanks.

[tesoke]

no idea? please help.

[Pecoflyer]

As what you require goes against all principles of good spreadsheet design, I cannot help.
I also cannot help thinking you are pulling my leg, to say the least.

Good luck finding your solution

[tesoke]

No, I am not trying to pull your leg. I am just trying to find the answer of my confusing question. I am a good user. Thanks anyway.

[gebobs]

Originally Posted by tesoke

Yes, but the problem is that if I add different columns, it leads to increase in the number of columns. So, I cannot see all data in screen and have to move left and right. I need to see all data in screen to decide based on them.

How are you going to make any decisions when you can't do any analysis? That would be terrible design and you would certainly regret it later.

One can manage dozens of columns easily in a single table. Limiting yourself to the number of columns that you can see on your screen seems to be a bit obsessive/compulsive and is no more necessary than limiting the number of rows in the same way. Since you say that you have a long list of persons in your table, this apparently isn't an issue.

There are ways to manage large tables thus. For starters, you can freeze rows and columns to keep your field headers and employee names visible as you scroll.

[tesoke]

Thank you. I will try with single data and more columns. Thanks.