This question has been asked before so apologies for duplication, mine is slightly different though.
I have a table with a few columns in, one column has codes in it, split by commas. I need to split this column into separate rows, with the rest of the data.
Example below, just a few columns (dashs represent new column)
I need to turn this......
Grower - Location - GrowerCode
Grower1 - USA - D1769, D1760, D1763
Grower2 - Europe - D5630
Grower3 - Asia - D2356, D2537
........ into this:
Grower - Location - GrowerCode
Grower1 - USA -D1769
Grower1 - USA - D1760
Grower1 - USA - D1763
Grower2 - Europe - D5630
Grower3 - Asia - D2356
Grower3 - Asia - D2537
I managed to find a solution that splits the commas, but I am unable to see a way to include the rest of the columns in the output
I have a table with a few columns in, one column has codes in it, split by commas. I need to split this column into separate rows, with the rest of the data.
Example below, just a few columns (dashs represent new column)
I need to turn this......
Grower - Location - GrowerCode
Grower1 - USA - D1769, D1760, D1763
Grower2 - Europe - D5630
Grower3 - Asia - D2356, D2537
........ into this:
Grower - Location - GrowerCode
Grower1 - USA -D1769
Grower1 - USA - D1760
Grower1 - USA - D1763
Grower2 - Europe - D5630
Grower3 - Asia - D2356
Grower3 - Asia - D2537
I managed to find a solution that splits the commas, but I am unable to see a way to include the rest of the columns in the output