Hello,
How can i get data seperated by comma (,) vertical or among each other like this example.
screenshot_example_excel.JPG
See attachments for more info. I hope someone can help me out.
Kind regards,
Jeroen
Hello,
How can i get data seperated by comma (,) vertical or among each other like this example.
screenshot_example_excel.JPG
See attachments for more info. I hope someone can help me out.
Kind regards,
Jeroen
This can be accomplished using Power Query/Get and Transform. Load your file into PQ, Split the column using delimeter -- Comma. Then Unpivot the columns holding the data you just split.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Here is some VBA in case you need it. But column B must be formatted as Text for this to work, otherwise, Excel does not "see" the commas.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks