If you have a list of horizontal data and you want to turn it into vertical data then you need to use the index() function. As in the example below.
First, prepare a list of two non-repeating values, in my case “Nazwa” and “Kwota”. Then a list of recurring values to help with the search, I search by the “Etap” column.
The formula in the “Adres” column looks like this:
Nothing special. The real magic begins after this column. Index() function supported by Match().
Remember to confirm the index() function using the key combination Crtl+Shift+Enter.
Comments are closed, but trackbacks and pingbacks are open.