Trickyissue: convert a cell with multiple words to each new rows but maintain other column
Hello all,
It is a bit hard to explain in words, so please see the image below.
Basically, I want to change [one cell with multiple words separated by commas]:photos to multiple columns but keep the [rest of the data]: dmg, value1, value2
excel issue.jpg
And I have about 1000 rows of these so I manually doing it will not work
use Power Query and Split by delimiter ( , ) to the rows by [photos] column
sandy
Learn Power Query (XL2010/2013 require PQ add-in)I want to see what you are trying to achieve, not how you are trying to do itWhat makes learning so hard is the amount of knowledge you have to unlearn
Why is my program not doing what I expect?
Because you set the wrong expectations. Rewire your brain
Power Query and Split by delimiter ( , ).
Got it will try. Much thanks,
But wouldn't this simply change [photo] to multiple new rows without copying [dmg, value1, value2]?
Re: Trickyissue: convert a cell with multiple words to each new rows but maintain other co
I don't understandOriginally Posted by ArkLade
here is simple way to achieve what you want to achieve
select column [photo] in Power Query Editor then
sbdtr.png
next time attach example EXCEL file with your data and expected result NOT A PICTURE
Sorry about the image, new to this forum.
First of all much thanks for letting me know such tool exists.
But I am still quite lost on how to use it.
If I go to Power Query Editor, everything is grayed out.
Sorry for being a noob, but can you provide a quick step-by-step on how I can use Power Query Editor to use [Cplit Column by Delimiter]?
select your data and use - Ctrl T
then Data tab - From Table
it will open PQ Editor where you can select column [photos]
the rest you know...
on the end Close&Load...
to learn more read this: Power Query
Thank you so much! it worked!
You are welcome
if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks