K
K
koliaua2021-01-10 17:51:14
Google Sheets
koliaua, 2021-01-10 17:51:14

How to move data from a column?

5ffb145238229022578010.png
In column A in lines 2, 14, 26, etc. there is data that needs to be transferred to column C lines 2,3,4..., how to do it?
Ideally, it would be if data from the cell indicated in B2 would be transferred to cell C2 and the data would turn from ADBE [NASDQ] to ADBE and NASDQ in neighboring cells

Answer the question

In order to leave comments, you need to log in

3 answer(s)
M
mityayka1, 2021-01-10
@koliaua

=dwlink(b2)

G
Grigory Boev, 2021-01-10
@ProgrammerForever

Selects non-empty values
=filter(a:a;a:a<>"")
​​And the resulting value can be parsed with REGEXTRACT ()
Or use something like this:

function REGEXTRACTALL(rows, regExp, flags) {
  flags = flags || "gmi";
  return rows
  .map(r=>r[0])
  .map(el=>(el+"").match(new RegExp(regExp, flags)));
}

Use something like this:
=REGEXTRACTALL(filter(a:a;a:a<>""), "([A-Za-z]+)", "gmi")

A
Alexander Ivanov, 2021-01-11
@oshliaer

Maybe this is for you

=ARRAYFORMULA(IFERROR(
  SPLIT(
    VLOOKUP(
      B:B,
      {ADDRESS(ROW(A:A),COLUMN(A:A),4),A:A},
      2,
      0
    ),
  "[\[\]]")
))

5ffc0c28b8657634958834.png
Please note that the formula must be entered in the first row of the Table.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question