Forum Discussion
formula or script to change 'space delimited' rows to column separated
looking to see if anyone knows how to take a long row of data separated by spaces and convert that data into individual columns per row.
CSM_G On the Data ribbon, find "Text to columns". Step through the wizard and chose a space as the delimiter.