Suppose I have a table
date NY Chicago SF---------------------------1/1/2020 10 15 201/2/2020 15 20 10
I want to reformat a table into the form
date city-----------------------1/1/2020 NY 101/2/2020 NY 151/1/2020 Chicago 151/2/2020 Chicago 20
Please advise.
Best Answer