Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
60
Views
Topic starter
I've got data that looks like this (all one cell
| Original |
| * HR 59 <60 Generated at 15:20:38. |
| **ABPs 96 <100 Generated at 15:20:32. |
| **ABPs 96 <100 Ended. |
| **ABPs 96 <100 Generated at 15:20:19. |
| * HR 59 <60 Ended. |
| **ABPs 82 <100 Ended. |
| **etCO2 7.1 >6.8 Ended. |
| **etCO2 7.1 >6.8 Generated at 15:19:28. |
| * HR 142 >135 Generated at 15:19:08. |
However I want it to look like this.. I can get rid of the Ended bit/Generated at ...bit but how can I separate out the rest of it into the 59 and <60 (note that some of the data will have > instead of <.. I've tried quite a few things but so far no success 🙂 Thanks as always.
| Desired | |||
| * | HR | 59 | <60 |
| ** | ABPs | 96 | <100 |
Posted : 01/07/2017 6:55 am
Hi Anne,
It looks like you have a space delimiter you can use to separate the data? Transform tab > Split by Delimiter, then select the Space delimiter.
Mynda
Posted : 01/07/2017 7:18 am
