Excel input in pivot format

[sanjayn89]

Hi Everyone ,

I need a small help i have a excel file in which data is in pivot format as attached .

In Alteryx i have to read the data from the file in every sheet i have different tables as per the city and line number  as shown in the image . what i want is to repeat the city "Tokyo" and the Line "8323_SPL_01" to repeat in the new column as per the mention city and line number for every table in the sheet . 

What is the way in which this can be read. I have upload the 2 pictures in "Input" its showing the excel data and in "Output " its showing the Desired output from alteryx.

[BrandonB]

The easiest way is likely a multi-row formula that would be used to create a new column. It would look to see if row minus 1 of the second column contained Line # and if so, use the value of the first column. If not, use the value of the row above.