Test2

[wilkisa]

I switched to Enhanced WYSIWYG mode and am entering my test data.

2013	115	Archie	10	xx10	LARIAT	861.13	7,836.28
2013	115	Archie	11	xx11	AIRPLANES	944.30	7,705.49
2013	115	Archie	12	xx12	JAYBIRD	428.98	3,228.08
2013	136	Charles	1	xx13	CHAINS	322944.84	3,058,494.52
2013	136	Charles	1	xx14	CHAINS	395633.08	3,829,923.30
2013	136	Charles	2	xx15	INDIANA	11380.82	92,753.68
2013	136	Charles	2	xx16	INDIANA	365947.1	3,165,615.50

<colgroup><col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:3840;width:79pt" width="105"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:5412;width:111pt" width="148"> <col style="mso-width-source:userset;mso-width-alt:4169;width:86pt" width="114"> <col style="mso-width-source:userset;mso-width-alt:4132;width:85pt" width="113"> </colgroup><tbody>
</tbody>

 

[Peter_SSs]

I switched to Enhanced WYSIWYG mode and am entering my test data.

OK, well that is starting to look good to me!

You should post your screen shots of SOURCE and TARGET back in the original thread.

One thing you should do is copy the data to new sheets because to indicate the columns/rows you'll (for your screen shot) probably need to move the data across a column and down a row to allow inserting of column/row labels. For example, in my table below I've used row 1 and column A for the labels and the word "Name" is actually in cell B2 (not A1) in the dummy sheet I used to produce that.

If you have some columns that are not relevant to the problem, you can leave them out of the dummy sheet as below.

	A	F	G	Z
1	Name	Age	Amount	Grade
2	Tom	55	32	B
3	Jen	48	25	A

<tbody>
</tbody>

I'm assuming the table in your last post was created using Firefox but I'll give you the steps for Internet Explorer in case you want to use that in the future. At least this is what works for me.

If your normal Message Editor Interface setting is "Standard editor - Extra formatting controls"

1. Above the Quick Reply window click to switch to "WYSIWYG" (as you did)

2. With borders on all the cells Copy & Paste to your post. (The borders will probably not show at this stage)

3. Click "Go Advanced" or "Preview Post" at the bottom right of the Quick Reply window. (The borders will probably not show at this stage but you may see faint borders in the Quick Reply/Your Message window - not the actual Preview of your post)

4. In the Quick Reply/Your Message window click somewhere on the table (with faint borders)

5. Above the reply window there should be another row (or two) of toolbar icons, including a Table toolbar. Click the Table Properties icon (2nd from left)

6. In Table Style, choose Full Grid, OK