I have the fun task of creating a database for a group at work that has been working off tables in a word document of all things. The format of their table is a title row at the top, a row of fields, then below that a merged cell row with a narrative. I want to move the merged cell row up with the fields so all the data is in a single row.

Attached Images

2023-06-08_14-26-30.png (22.0 KB, 7 views)

This is actually surprisingly easy and won't need a macro. I've attached a Word document showing the steps I took to convert this layout.

Assuming your table is EXACTLY as you show and doesn't contain any cells with multiple paragraphs this will work.

The steps you need to make are:
1. Edit the Cell which contains FieldName3 to add a paragraph after it so it contains
FieldName3
NarrativeField

2. Select the entire table and Convert Table to Text, separate text with paragraph marks

3. While that text is selected, Convert Text to Table, 4 columns & separate text at Paragraphs

I've attached a doc showing the dialog box settings you need to use.

If you do have cells with multiple paragraphs, you need to temporarily replace them with something else eg Find and replace ^p with xxx. After you recreate the table and paste it into Excel, do the reverse search and replace (Hint: In Excel, a return in a cell is Ctrl-J in the replace box).

Attached Files

Table_Reformatting.docx (76.7 KB, 1 views)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Thank you very much.