Excel O365 - Need to separate data in a column into 3 columns 1

[cjbrown815]

Hello,
I have a spreadsheet that has 3 pieces of data (text)(Sample Type ID, Description, Suite) in column A, I need to separate that data based on row location into separate columns (Column A = Sample Type ID, Column B = Description, Column C = Suite)

Sample Type ID/ Description/ Suite/
BRSRENV-LIST_ 001
BRSR_Drain
Culture Process room
BRSRENV-LIST_ 002
BRSR_Drain Cover
Culture Process room
BRSRENV-LIST_ 003
BRSR_Drain Basket
Culture Process room
BRSRENV-LIST_ 004
BRSR_Floor by Drain
Culture Process room
BRSRENV-LIST_ 005
BRSR_North Ceiling Make Room
Culture Process room

It should be

Sample Type ID/ Description/ Suite
BRSRENV-LIST_ 001 BRSR_Drain Culture Process room


BRSRENV-LIST_ 002 BRSR_Drain Cover Culture Process room


BRSRENV-LIST_ 003
BRSR_Drain Basket
Culture Process room
BRSRENV-LIST_ 004
BRSR_Floor by Drain
Culture Process room
BRSRENV-LIST_ 005
BRSR_North Ceiling Make Room
Culture Process room



Thanks

-CJ

SQL2014// CR Pro 11.5.0.313// Windows 7 Enterprise

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

Remember getting data like this and using a formula to get the data from column A into, in this case, column B, C or D.

So you use the MOD() function to detect a modulus of 3 to get the data into the proper column.

Then to accumulate the data into the proper rows/groups, you use look for the minimum or maximum modulus to begin the accumulation in order to get all three values into the same row and then start all over again for the next three.

And, oh yes, please use TGML tags to display your columnar data properly...
[pre]

Sample Type ID Description Suite
BRSRENV-LIST_ 001 BRSR_Drain Culture Process room

[/pre]

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[SkipVought]

Here's a sample workbook.
[pre]
'
0 1 2
Sample Type ID Sample Type ID Description Suite
BRSRENV-LIST_ 001 BRSRENV-LIST_ 001 BRSR_Drain Culture Process room
BRSR_Drain BRSR_Drain Culture Process room
Culture Process room BRSR_Drain Cover Culture Process room
BRSRENV-LIST_ 002 BRSRENV-LIST_ 002 BRSR_Drain Cover Culture Process room
BRSR_Drain Cover BRSR_Drain Cover Culture Process room
Culture Process room BRSR_Drain Basket Culture Process room
BRSRENV-LIST_ 003 BRSRENV-LIST_ 003 BRSR_Drain Basket Culture Process room
BRSR_Drain Basket BRSR_Drain Basket Culture Process room
Culture Process room BRSR_Floor by Drain Culture Process room
BRSRENV-LIST_ 004 BRSRENV-LIST_ 004 BRSR_Floor by Drain Culture Process room
BRSR_Floor by Drain BRSR_Floor by Drain Culture Process room
Culture Process room BRSR_North Ceiling Make Room Culture Process room
BRSRENV-LIST_ 005 BRSRENV-LIST_ 005 BRSR_North Ceiling Make Room Culture Process room
BRSR_North Ceiling Make Room BRSR_North Ceiling Make Room 0
Culture Process room 0 Culture Process room

[/pre]

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein