I received from a colleague information in a Word doc that is arranged as:
Style Number
Fit Note
Fit Note
Style Number2
Fit Note
Fit Note
etc.
I need this information in horizontal table form to look like:
Style Number Fit Note Fit Note
Style Number 2 Fit Note Fit Note
Transpose doesn't solve my problem because it puts all the information in one row. Can anyone help me to figure out how to transpose this data into a table? I am assuming it would have something to do with arrays and transposing, or a macro, but am just not sure how to go about this. I run into this issue all the time.
Thanks!
Bookmarks