I am having an impossible time finding a solution for this. I need to combine cell contents in an unusual way (see below), based on if there is an "x" in column A. See below for the exact representation of what I need to do in a worksheet with 200,000 total cells of content. Is there any hope? Anyone who can help will be my personal hero for life, and you may save a life (mine!)!
Current data format:
[TABLE="class: stg_table tborder sortable"]
<tbody>[TR]
[TH][/TH]
[TH]col1 [/TH]
[TH]col2 [/TH]
[TH]col3 [/TH]
[TH]col4 [/TH]
[TH]col5[/TH]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row2[/TD]
[TD]x[/TD]
[TD]a[/TD]
[TD]l[/TD]
[TD]g[/TD]
[TD][/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row3[/TD]
[TD][/TD]
[TD]b[/TD]
[TD]m[/TD]
[TD]h[/TD]
[TD]Title A[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row4[/TD]
[TD][/TD]
[TD]c[/TD]
[TD]n[/TD]
[TD]i[/TD]
[TD][/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row5[/TD]
[TD]x[/TD]
[TD]d[/TD]
[TD]o[/TD]
[TD]j[/TD]
[TD][/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row6[/TD]
[TD][/TD]
[TD]e[/TD]
[TD]p[/TD]
[TD]k[/TD]
[TD]Title B[/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row7[/TD]
[TD][/TD]
[TD]f[/TD]
[TD]q[/TD]
[TD]l[/TD]
[TD]Title C[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row8[/TD]
[TD][/TD]
[TD]g[/TD]
[TD]r[/TD]
[TD]m[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The above table can be copied and dropped directly in to Excel
Needed format:
[TABLE="class: stg_table tborder sortable"]
<tbody>[TR]
[TH][/TH]
[TH]col1 [/TH]
[TH]col2 [/TH]
[TH]col3 [/TH]
[TH]col4 [/TH]
[TH]col5[/TH]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row2[/TD]
[TD]x[/TD]
[TD]a b c[/TD]
[TD]l m n[/TD]
[TD]g h i[/TD]
[TD]Title A[/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row3[/TD]
[TD]x[/TD]
[TD]d e f g[/TD]
[TD]o p q r[/TD]
[TD]j k l m[/TD]
[TD]Title B/Title C[/TD]
[/TR]
</tbody>[/TABLE]
The above table can be copied and dropped directly in to Excel
If no solution to the above can be found, perhaps I could do this one column at a time by copying the individual columns into separate sheets, run a Macro, then copy the reformatted info back (EG, just do column A and one other column at a time like below). I am not sure of any other options or approaches to accomplishing this, but an open to thoughts.
Current data format:
Needed format:
Current data format:
[TABLE="class: stg_table tborder sortable"]
<tbody>[TR]
[TH][/TH]
[TH]col1 [/TH]
[TH]col2 [/TH]
[TH]col3 [/TH]
[TH]col4 [/TH]
[TH]col5[/TH]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row2[/TD]
[TD]x[/TD]
[TD]a[/TD]
[TD]l[/TD]
[TD]g[/TD]
[TD][/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row3[/TD]
[TD][/TD]
[TD]b[/TD]
[TD]m[/TD]
[TD]h[/TD]
[TD]Title A[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row4[/TD]
[TD][/TD]
[TD]c[/TD]
[TD]n[/TD]
[TD]i[/TD]
[TD][/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row5[/TD]
[TD]x[/TD]
[TD]d[/TD]
[TD]o[/TD]
[TD]j[/TD]
[TD][/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row6[/TD]
[TD][/TD]
[TD]e[/TD]
[TD]p[/TD]
[TD]k[/TD]
[TD]Title B[/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row7[/TD]
[TD][/TD]
[TD]f[/TD]
[TD]q[/TD]
[TD]l[/TD]
[TD]Title C[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row8[/TD]
[TD][/TD]
[TD]g[/TD]
[TD]r[/TD]
[TD]m[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The above table can be copied and dropped directly in to Excel
Needed format:
[TABLE="class: stg_table tborder sortable"]
<tbody>[TR]
[TH][/TH]
[TH]col1 [/TH]
[TH]col2 [/TH]
[TH]col3 [/TH]
[TH]col4 [/TH]
[TH]col5[/TH]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR="class: alt1, bgcolor: #FFFFFF"]
[TD]row2[/TD]
[TD]x[/TD]
[TD]a b c[/TD]
[TD]l m n[/TD]
[TD]g h i[/TD]
[TD]Title A[/TD]
[/TR]
[TR="class: alt2, bgcolor: #F5F5F5"]
[TD]row3[/TD]
[TD]x[/TD]
[TD]d e f g[/TD]
[TD]o p q r[/TD]
[TD]j k l m[/TD]
[TD]Title B/Title C[/TD]
[/TR]
</tbody>[/TABLE]
The above table can be copied and dropped directly in to Excel
If no solution to the above can be found, perhaps I could do this one column at a time by copying the individual columns into separate sheets, run a Macro, then copy the reformatted info back (EG, just do column A and one other column at a time like below). I am not sure of any other options or approaches to accomplishing this, but an open to thoughts.
Current data format:
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;">A B </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;">x a </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;"> b </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;"> c </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;">x d </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;"> e </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;"> f </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;"> g </code>
Needed format:
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;">A B </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;">x a b c </code>
- <code class="language-vb" style="font-family: Consolas, Monaco, 'Courier New', Courier, monospace;">x d e f g </code>