Drag cells keeping the reference in incremental order
I have a table of a name and a country:
I'm using concatenation, taking A2 and B2 as an example to output the following text in two rows
=CONCAT("Her name is ",A2)
=CONCAT("Her country is ",B2)
Now I'm selecting the concatenation formulas of these two cells and drag them to the bottom so that this can be replicated with the other two names. But since the cocatanated strings of text are in two different cells, it doesn't do that. It jumps a value and doesn't reference the table values in incremental order. Any help would be appreciated.
Current incorrect output:
Solution
If your are on Microsoft-365 then try-
=TEXTSPLIT(TEXTJOIN("|",1,"Her name is " & A2:A4 & "|Her country is " & B2:B4),,"|")
For older version of excels could try-
=INDEX({"Her name is ";"Her country is "},MOD(ROW(A2),2)+1) & INDEX($A$2:$B$4,ROUNDDOWN(ROW(A2)/2,0),MOD(ROW(A2),2)+1)
- How to share memory of a byte array between a C# and Python processes
- Merge two arrays with same keys
- Convert a 2d array into a hierarchical multidimensional array with conditionally determined subarray data
- Filter out rows rows of a 2d array if not related to rows of another 2d array and merge their data
- Merge two sets of deep rows in a multidimensional array identified by related column values
- Creating two dimensional arrays in Rust
- Drag cells keeping the reference in incremental order
- Use native Excel functions to count occurrences over threshold
- How to create an interface which is an array of a simpler interfaces?
- Pointer arithmetic in C when used as a target array for strcat()
- Prepend strings from a flat array to the corresponding elements of each row of a 2d array
- Swap the first and the last words and reverse all the middle characters
- VB.net Hex to byte array translated to C#
- Group rows of a 2d array by an identifying column and sum another column within each group
- Join data from two database tables by a relating column
- Merge two flat arrays into a new flat array with no empty values
- Split array into chunks
- I would like to modify the values of specific elements in a list in an efficient manner
- Array to CSS style parameters Conversion
- Application.Match is not working correctly with dates in a VBA array
- How console log element value during map() in javascript?
- Populate an associative array with keys defined by an array and values from a static value
- Group 2d array rows by one column and build a comma-separated string from another column's values within each group
- When isset() should be used on Array without specifying key?
- Get the index of a value in a Bash array
- Adding Elements to a KeyValuePair<X, Y>
- Why allocate memory? (C++)
- Sum of absolute differences of a number in an array
- Overwrite row data in a 2d array when related data is found in another 2d array
- Java ArrayList<ArrayList<>> indexOf regardless of the order