Forum Discussion
Split Column with multiple values in same column
Hi I have a file with multiple columns, where each column can be one or more companies. Something like the following format: Date | Company1 | Company2 01-02-2019 | 1000 ...
Anonymous
Right click on the date column and select Unpivot Other Columns.
---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."
Hi
Didn't work because doing that I've lost the relation between the companies and the amounts.
😞
Thanks
I guess I'm unclear what you mean by the "relation between the companies and the amounts"
You started with something like this, correct?:
And you should have ended up with something like this:
What do you need that this does not have?
The difference is that in one Column the file can have more than one Company, like these: