I have certain data that I would like to extract and am wondering if Power Query can do this? In the attachment cells J4 and K4 I want the data from these single cell into a muliple cells that I can get to the relationship SS and the number 258.24. There are 8 or more department that each have this configuration. Can Power Query get this?
Thanks
Ron
Hi Ronald,
I'm not sure I fully understood as there wasn't a 'desired result' example in your file, but I've had a go at what I though you meant. You can see in the attached file. I hope that helps point you in the right direction.
Mynda
Mynda,
I had the answers in a different format for rows 6 -10. My real question was for the data in J5 and K5. There is typically 5 to 6 items listed in each cell as text separated by a hard return. I want access to those individual items. I would like the second item in J5 'SS' in a cell and in the cell next to it
258.24. Is this possible?
Ron
Hi Ronald,
I'm confused, you said " I would like the second item in J5 'SS' in a cell and in the cell next to it
258.24. Is this possible?". That's what's on Sheet2 of the file I attached, see cells A3 and B3.
Mynda
