Trusted Members
December 20, 2019
Manually this can be done by
1) Unmerging cells
2) Text to columns with only the other delimited box selected and do ctrl+j (line break)
3) as the data is now in columns, select the resulting cells, copy
4) click in a8 paste>special>transpose
VBA would ultimately do the same thing if it was a repetitive task
Purfleet
Trusted Members
December 20, 2019
At least we both did it the same way!
if you had to do this regularly, say daily or weekly, they i would say a macro is the best way to do it or if you had multiple cells with maybe 5 lines in each cell - however the VBA would be slightly different for each method.
It might be worth recording a Macro doing your steps then looking to see if you can amend the code to provide you with more flexibility.
Happy to help if you can make a start
Purfleet
1 Guest(s)