needexcelhelp
New member
- Joined
- Jan 17, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi. I have a large dataset from multiple experiments that are all in two columns, when in reality they should be split into 60 or so columns from 30 separate experiments. The dataset is long, > 20,000 rows, so manually cutting and pasting would be onerous. But they should all be of the same length. These are numerical data so the text to column command won't work. There must be an easy way to do this. Thanks in advance!