Macro to separate wrapped text cells to multiple rows

[Savuti]

Hello everyone, I am looking for a macro that will search down rows from column "A" to "AT" to look for any cells that contain wrapped text.

I have attached an image showing what I need to have done. The macro I have attached does what I need except for when there is an empty cell within the range - it halts the process and gives a runtime '13' error.

Can the attached macro be altered to ignore blank cells and search the entire row or a different macro in order. I would appreciate having a macro able to do this as it would save huge amount time.

Thank you

	A	B	C	D	E	F	G
1	Hammer Drill Toolbox	Apples Bananas	Dishwasher Stove	Ford Dodge Chevy	Susan Henry Peter	Houston	Orange Blue Purple
	A	B	C	D	E	F	G
1	Hammer	Apples	Dishwasher	Ford	Susan	Houston	Orange
2	Drill	Bananas	Stove		Henry		Blue
3	Toolbox				Peter		Purple
	A	B	C	D	E	F	G
1	Hammer	Apples	Dishwasher		Susan	Houston	Orange
2	Drill	Bananas	Stove
3	Toolbox

Sub SplitText()
    Dim MaxSize As Integer
    Dim rng As Range

    Set rng = Range("A1:J1")
    MaxSize = 0
    For Each Cell In rng
        Dim CurrentSize As Integer
        CurrentSize = UBound(Split(Cell.Value, vbLf))
        If CurrentSize > MaxSize Then
            MaxSize = CurrentSize
        End If
    Next
    Rows((rng.Row + 1) & ":" & (rng.Row + MaxSize)).Insert Shift:=xlDown
    For Each Cell In rng
        Dim SplitText
        SplitText = Split(Cell.Value, vbLf)
        Cell.Resize(UBound(SplitText) + 1).Value = Application.Transpose(SplitText)
    Next
End Sub

 

[Rick Rothstein]

Give this macro a try...

[table="width: 500"]
[tr]
	[td]Sub SplitTextDown()
  Dim Cell As Range, Txt() As String
  For Each Cell In Range("A1", Cells(1, Columns.Count).End(xlToLeft))
    Txt = Split(Cell.Value, vbLf)
    If UBound(Txt) > -1 Then Cell.Resize(1 + UBound(Txt)) = Application.Transpose(Txt)
  Next
End Sub[/td]
[/tr]
[/table]

 

[Savuti]

Rick, thank you, this works perfectly - saved me a lot of time.

 

[Savuti]

Rick, thank you for the reply, The macro works, however it only runs on the first row. Can it look down as many rows as need be. I have about 5000 rows. Any one of them can have wrapped text. I need the macro to search down and across all rows. Thanks

 

[Rick Rothstein]

Rick, thank you for the reply, The macro works, however it only runs on the first row. Can it look down as many rows as need be. I have about 5000 rows. Any one of them can have wrapped text. I need the macro to search down and across all rows.

Where does Row 2's values go to... their own rows (starting on Row 4 for your example) or do they first fill in any blanks created by the expansion from the row above (so that there would be not blank cells between non-blank cells within any single column)?

 

[Savuti]

Rick, I would need a new row(s) to be inserted below the row that has the wrapped text. So if there were three lines in a cell (apple, pear, peach) then two rows would be added below and apple would stay in it's original row and pear and peach would have their own rows below. I hope I have explained well enough. Thanks

 

[Savuti]

Hello folks, I have a clearer explanation of what I am looking for. I need a macro to search
down a number of rows (about 5000) and look for any cells that have multiple lines of text (wrapped text) across columns "A" to "AT".
I would need a new row(s) to be inserted below the row that has the wrapped text. So for example if there were three lines in a cell on row 4 (apple pie, pear, peach) I want two rows to be added below row 4, one with "pear" and one with "peach" ..... "apple pie" would stay in it's original row. I have attached an image to show what I need.
Thanks

[TABLE="width: 357"]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]<colgroup><col width="56" style="width: 42pt;" span="3">[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]<col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3584;">[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]<col width="56" style="width: 42pt;" span="4">[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]<tbody>[TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Before[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 84, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]A[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]B[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]C[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]D[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]E[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]F[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]G[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]1[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Hammer
[/COLOR][/SIZE][/FONT][FONT=Arial][SIZE=2][COLOR=#000000]    Drill
    Toolbox
    [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Apples
[/COLOR][/SIZE][SIZE=2][COLOR=#000000]    Bananas[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 84, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Dishwasher
[/COLOR][/SIZE][SIZE=2][COLOR=#000000]    Stove[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Susan
[/COLOR][/SIZE][/FONT][FONT=Arial][SIZE=2][COLOR=#000000]    Henry
    Peter[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Houston[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Orange
[/COLOR][/SIZE][/FONT][FONT=Arial][SIZE=2][COLOR=#000000]    Blue
    Purple[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Salt[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Pepper[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 84, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Herbs[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Spice[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Garlic[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Water[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Chili[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 84, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]After[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]A[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]B[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]C[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]D[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]E[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]F[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]G[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]1[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Hammer
[/COLOR][/SIZE][/FONT][FONT=Arial][SIZE=2][COLOR=#000000]    
    [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Apples
[/COLOR][/SIZE][SIZE=2][COLOR=#000000]    [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 84, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Dishwasher
[/COLOR][/SIZE][SIZE=2][COLOR=#000000]    [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Susan
[/COLOR][/SIZE][SIZE=2][COLOR=#000000]    [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Houston[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Orange
[/COLOR][/SIZE][SIZE=2][COLOR=#000000]    [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]2[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Drill[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Bananas[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Stove[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Henry[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Blue[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]3[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Toolbox[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Peter[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Purple[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: #F2F2F2"][FONT=Arial][SIZE=2][COLOR=#000000]4[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Salt[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Pepper[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 84, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Herbs[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Spice[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Garlic[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Water[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000]  [/COLOR][/SIZE][/FONT][TD="width: 56, bgcolor: transparent"][FONT=Arial][SIZE=2][COLOR=#000000]Chili[/COLOR][/SIZE][/FONT][/TD]
[FONT=Times New Roman][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TR]
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT]</tbody>[/TABLE]