Creating table from email body and repeating columns

I want to convert an email body from a website form to an easy to read table so we can enter it into our Access database. This is what would come in after copy/pasting the email body into Excel. ...

Macros and VBA

Power BI

Patrick2788

Jul 06, 2023

achow1565

This will do it. I hope you have 365!

=LET(
    header, INDEX(list, SEQUENCE(, 13, 1, 2)),
    organized, DROP(
        REDUCE(
            "",
            header,
            LAMBDA(a, v,
                LET(
                    r, FILTER(ROW(list), list = v) + 1,
                    IFERROR(HSTACK(a, INDEX(list, r)), "")
                )
            )
        ),
        ,
        1
    ),
    VSTACK(header, organized)
)

I created a function to do this. You'll find it all in the workbook attached.

REDUCE 7.6.xlsx15 KB

Forum Discussion

Creating table from email body and repeating columns

Share

Resources