Unstack Your Excel Data From Columns To Rows

OMG I LOVE YOU!!! I've spent an hour scrolling through videos and the all want to use a formula. I just want my data cleaned up, and get rid of the stack. Thank you! Thank you! Thank you!

Thank you =شُكرا

Good tip

Thanks for this trick dear, but how to put beside the street name cell the word ( street name) not in a column header but in rows beside each street name put in the cell beside it its title ( street name)

Very nice solution! Thanks Barbara. Thumbs up!!
PS - Here is a formula solution that would work: =OFFSET($C$4,((ROWS(D$4:D4)-1)*3)+COLUMNS($D4:D4)-1,0). Copy right and down.
or this one: =INDEX($C$4:$C$12,((ROWS(D$4:D4)-1)*3)+COLUMNS($D4:D4))