Reformat data - multiple Columns to rows

Attached is a Sample of data as it currently exists and then how it is needed to be reformatted.

Each Customer Name (Source Column A) has the potential to have data in 16 columns (Columns C:R)

I need to instead have the data be potentially 16 rows for each customer. (But then if the data in row is blank, then to not show that data).

The Outcome tab of the attached sheet would show how the layout would need to be formatted.

So for example, the First name (ALL909) has data in 6 of the 16 columns. So there should only be 6 rows of data for ALL909 when it is finalized on the Outcome tab.