Комментарии:
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))