[Photo of the Excel table] 1 But the main problems are that; the column name is changing its address sometimes ( column address shifting within its row), so you cant fix an address in formulation, how can i search and find it ( city name) and gets the numerical values under it? And when you have found the column name in a way, it can sometimes contain 1-2 or 4 numerical values under it, how to order them on a different sheet under the same column header, with an vba code or sth ( i have about 40.000 rows with numerical values )
To summarize again list (row) all numbers of (for example) Istanbul on a column. Thanks in advance, smart people
I need to see the numerical values in time/dimension of the same column header, so when i use vlookup, match/index, i just get a total number of amount for a time period so it is useless, we have to see the every changes on the number in the city according to time
