Hi everyone - I've been working on a macro for transposing a simple dataset, as set out below, and have hit a brick wall. As you can see, the rows may contain blank cells (e.g. "Name 2" does not have anything in the first or third 'periods', just a middle one), so I'm really looking to transpose just the populated cells under "From", "To" and "Amount", plus add the name on each row.

There's probably a simple solution, but can anyone help?

x.jpg