D Don Oct 28, 2008 #1 I'm trying to move grouped data from a single collum to multible collums. Each group is separate by a comma
I'm trying to move grouped data from a single collum to multible collums. Each group is separate by a comma
M Max Oct 28, 2008 #2 I'm trying to move grouped data from a single collum to multiple collums. Each group is separate by a comma Click to expand... Try Data > Text to Columns, delimiter: comma -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik ---
I'm trying to move grouped data from a single collum to multiple collums. Each group is separate by a comma Click to expand... Try Data > Text to Columns, delimiter: comma -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik ---
R Roger Govier Oct 28, 2008 #3 Hi Don Ensure that you have sufficient blank columns to the right of your column of data. Data>Text to Columns>Delimited>tick Comma>Finish
Hi Don Ensure that you have sufficient blank columns to the right of your column of data. Data>Text to Columns>Delimited>tick Comma>Finish