Forum Discussion
Cambiar posición celdas
Hola buenas tengo el siguiente caso. Necesito poner en la celda titulo, lo que se encuentra en la celda B3, se que puedo poner en D2:=B3 Sin embargo si luego quiero quitar la linea 3 me cambi...
afrutos Okay! Now I get it. I'm a big fan of Power Query and such a task can easily be performed with it. See attached. I didn't try to make the query very sophisticated but see if you can get it to work. If you've never worked with PQ, you might find the link below helpful.
https://exceloffthegrid.com/power-query-introduction/
Oh thank you and once in PQ what did you you? I mean what steps you did?
afrutos If you are somewhat familiar with PQ, you should be able to follow the applied steps. If you are new to PQ, you need to do some studying first. Nothing I can explain in easily in this forum. There are plenty resources on line that can explain it better than I.