I am trying to set a string into a range of cells. The string has multiple items on each line, space delimited, and multi lines, with carriage return separating each. See data example below:
A B C D E
A B C D E
A B C D E
I would like the first line to be placed in the first row, with a letter in each respective column, 2nd line in the 2nd row, with a letter in each column etc. See attached.
I did it manually with for-loops but I was wondering if there was a cleaner\simpler way? I tried placing the data into an array and then using Transpose but I cannot get it to work with a 2d array for what I'm trying to do.
Bookmarks