Forum Discussion
Multiple values in each cell
Hello all! I have recently downloaded data collected from a questionnaire but I notice that I have several values in each cell. How can I ... 1. Convert each 'new line' of value to it's own ...
NikolinoDEThanks for your reply.
I have attached a file below.
I think it is only counting the first value in each cell and not all of them?
FREQUENCY function
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019
The table is pivoted, so I can't help you because my knowledge about it is very poor (to put it mildly). A specialist like Mr Baklan has to work here to provide a quick and efficient solution :-).
Sorry that I took your time and couldn't give you a quick solution.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)