모두 안녕!
For a research project I need to combine continuous data measured at the OR with own data. The electronic patient system can give me an exportfile as added to this post. The extraction from relevant data is not handy at all. I tried several things to make the data a bit more structured but I didn't succed. I installed Kutools to delete al the non-printing characters and completed the 'Text to columns' wizard, yet the problem is that the content of each cell is different. e.g. one cell has temperature as last variable, and the following cell has heartrate as last variable.
문제: 값이 정렬되는 방식으로 셀의 데이터를 오른쪽의 여러 열로 분할하는 방법이 있나요? " 다음에는 변수 이름이 먼저 나오고 그 뒤에 값이 옵니다.
시간 내 주셔서 감사합니다.
For a research project I need to combine continuous data measured at the OR with own data. The electronic patient system can give me an exportfile as added to this post. The extraction from relevant data is not handy at all. I tried several things to make the data a bit more structured but I didn't succed. I installed Kutools to delete al the non-printing characters and completed the 'Text to columns' wizard, yet the problem is that the content of each cell is different. e.g. one cell has temperature as last variable, and the following cell has heartrate as last variable.
문제: 값이 정렬되는 방식으로 셀의 데이터를 오른쪽의 여러 열로 분할하는 방법이 있나요? " 다음에는 변수 이름이 먼저 나오고 그 뒤에 값이 옵니다.
시간 내 주셔서 감사합니다.