Convert 2D Array into 1D Array with Concatenate

[Technical_details]

Hi,

i want to retrieve all the rows from the 2D array and concatenate and form as 1D array. How can it be achieved. Attached a sample input and expected output format. Can someone helpout.

[GerdW · Accepted solution]

Hi detail,

autoindex each row, then use ArrayToSpreadsheetString. Cleanup the string using TrimWhitespace (to remove trailing EOL chars):

This was an easy homework, wasn't it? 😉

[Technical_details]

Hi Gerd

Wow that was a great solution. thanks 

[Technical_details]

Hi,

The same data if i require without the '-' how could i get it. Instead of 0-1-2-3 if i need to get as 0123.

[GerdW]

Hi details,

use ConcatString instead of Array2SpreadsheetString…

[Yamaeda]

---

@Technical_details wrote:

Hi,

The same data if i require without the '-' how could i get it. Instead of 0-1-2-3 if i need to get as 0123.

---

Use Empty string as separator.

[ben64]

---

Yamaeda a écrit :

---

---

Use Empty string as separator.

---

No that doesn't work, it will add the default separator (tab) in this case.

Ben64

[Yamaeda]

So let it be tab separated and add a Search and Replace with empty string. 🙂

/Y

[Yamaeda]

Or better, change the Array to Spreadsheet string to a Concatenate strings.

/Y

[GerdW]

Hi Yamaeda,

why not redirect to message #5?