Hi,
I'm wondering if there's an easy/automated way to make multiple strings of data from a large data set. The thing is i would like to use information in another cell to determine when a new string should be created. The issue that I'm having is coming up with a formula, or logic, to use a "start" and "stop" for the data that'll be used in to create the string(s). Below is an example from my data. I'd like for any cell in column B that has the same SKU in column A to be made into a string separated by commas.
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]18[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]21[/TD]
</tbody>
Ideally, this is what it would look like after all said and done, but I'd be fine if it just repeated the information for however many instances there's duplicate information in column A. Meaning: rows 3 through 6 in my example above would still exist and the string created in column C, shown below, would be duplicated for each line (I hope that makes sense).
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
</tbody>
I'm wondering if there's an easy/automated way to make multiple strings of data from a large data set. The thing is i would like to use information in another cell to determine when a new string should be created. The issue that I'm having is coming up with a formula, or logic, to use a "start" and "stop" for the data that'll be used in to create the string(s). Below is an example from my data. I'd like for any cell in column B that has the same SKU in column A to be made into a string separated by commas.
A | B | |
---|---|---|
combo | filename | |
00639-TAN | ABILENE-FEDORA_00639_TAN_01.jpg | |
03125-BROWN | ABRAHAM-VEST_03125_BROWN_01.jpg | |
03125-BROWN | ABRAHAM-VEST_03125_BROWN_10.jpg | |
03125-BROWN | ABRAHAM-VEST_03125_BROWN_11.jpg | |
03125-BROWN | ABRAHAM-VEST_03125_BROWN_12.jpg | |
03125-CHARC | ABRAHAM-VEST_03125_CHARC_01.jpg | |
03125-CHARC | ABRAHAM-VEST_03125_CHARC_10.jpg | |
03125-CHARC | ABRAHAM-VEST_03125_CHARC_11.jpg | |
03125-CHARC | ABRAHAM-VEST_03125_CHARC_12.jpg | |
03125-COPPR | ABRAHAM-VEST_03125_COPPR_01.jpg | |
03125-COPPR | ABRAHAM-VEST_03125_COPPR_10.jpg | |
03125-COPPR | ABRAHAM-VEST_03125_COPPR_11.jpg | |
03125-COPPR | ABRAHAM-VEST_03125_COPPR_12.jpg | |
02340-OFFWH | ACCELERATE-HOOD-FLEECE_02340_OFFWH_01.jpg | |
00817-YELLW | ACCELERATE-HP-SNAPBACK_00817_YELLW_01.jpg | |
06673-WAYEL | ACCELERATE-L-S-POCKET-TEE_06673_WAYEL_01.jpg | |
06673-WHITE | ACCELERATE-L-S-POCKET-TEE_06673_WHITE_01.jpg | |
05208-MULTI | ACCELERATE-PIN-PACK_05208_MULTI_01.jpg | |
06646-BLACK | ACCELERATE-S-S-STANDARD-TEE_06646_BLACK_01.jpg | |
06646-ROYAL | ACCELERATE-S-S-STANDARD-TEE_06646_ROYAL_01.jpg |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]18[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]21[/TD]
</tbody>
Sheet1
Ideally, this is what it would look like after all said and done, but I'd be fine if it just repeated the information for however many instances there's duplicate information in column A. Meaning: rows 3 through 6 in my example above would still exist and the string created in column C, shown below, would be duplicated for each line (I hope that makes sense).
A | B | C | |
---|---|---|---|
combo | filename | String | |
00639-TAN | ABILENE-FEDORA_00639_TAN_01.jpg | ABILENE-FEDORA_00639_TAN_01.jpg | |
03125-BROWN | ABRAHAM-VEST_03125_BROWN_01.jpg | ABRAHAM-VEST_03125_BROWN_01.jpg,ABRAHAM-VEST_03125_BROWN_10.jpg,ABRAHAM-VEST_03125_BROWN_11.jpg,ABRAHAM-VEST_03125_BROWN_12.jpg | |
03125-CHARC | ABRAHAM-VEST_03125_CHARC_01.jpg | ABRAHAM-VEST_03125_CHARC_01.jpg,ABRAHAM-VEST_03125_CHARC_10.jpg,ABRAHAM-VEST_03125_CHARC_11.jpg,ABRAHAM-VEST_03125_CHARC_12.jpg | |
03125-COPPR | ABRAHAM-VEST_03125_COPPR_01.jpg | ABRAHAM-VEST_03125_COPPR_01.jpg,ABRAHAM-VEST_03125_COPPR_10.jpg,ABRAHAM-VEST_03125_COPPR_11.jpg,ABRAHAM-VEST_03125_COPPR_12.jpg | |
02340-OFFWH | ACCELERATE-HOOD-FLEECE_02340_OFFWH_01.jpg | ACCELERATE-HOOD-FLEECE_02340_OFFWH_01.jpg | |
00817-YELLW | ACCELERATE-HP-SNAPBACK_00817_YELLW_01.jpg | ACCELERATE-HP-SNAPBACK_00817_YELLW_01.jpg | |
06673-WAYEL | ACCELERATE-L-S-POCKET-TEE_06673_WAYEL_01.jpg | ACCELERATE-L-S-POCKET-TEE_06673_WAYEL_01.jpg | |
06673-WHITE | ACCELERATE-L-S-POCKET-TEE_06673_WHITE_01.jpg | ACCELERATE-L-S-POCKET-TEE_06673_WHITE_01.jpg | |
05208-MULTI | ACCELERATE-PIN-PACK_05208_MULTI_01.jpg | ACCELERATE-PIN-PACK_05208_MULTI_01.jpg | |
06646-BLACK | ACCELERATE-S-S-STANDARD-TEE_06646_BLACK_01.jpg | ACCELERATE-S-S-STANDARD-TEE_06646_BLACK_01.jpg | |
06646-ROYAL | ACCELERATE-S-S-STANDARD-TEE_06646_ROYAL_01.jpg | ACCELERATE-S-S-STANDARD-TEE_06646_ROYAL_01.jpg |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
</tbody>
Sheet1