I have a spreadsheet that contains columns with multiple cells with carriage returns. I would like to split the carriage returns into new rows across the entire spreadsheet.
I would like a vb script to pull the data apart and place it into a new tab in the same workbook.
See the below for a sample dataset and required output.
Original data set - ALL IN ONE ROW IN SPREADSHEET W CARRIAGE RETURNS:
COL1 COL2 COL3 COL4 COL5 COL6
UNRD SVO31 A1S UNRD N
MTR AAI MTR ZZ
GRP ATB GRP AA
VMA AAA VMA BB
Required data set - DATA MOVED TO MULTIPLE ROWS IN SPREADSHEET:
R1 COL1 COL2 COL3 COL4 COL5 COL6
R2 UNRD SVO31 A1S UNRD N
R3 MTR AAI MTR ZZ
R4 GRP ATB GRP AA
R5 VMA AAA VMA BB