Manhattan Associates interview question

Normalize [this] table. Write query to get [this] data.