copy data from one tab to another as a list

[paul higginson]

Hello,

I'm trying to reference data from one tab to another.
The data on the first tab is in the form of numbers in individual cells.
I want to copy the contents of multiple cells (the numbers) and list them as desired on the other tab but within the same cell, is this possible.
I've found the 'CONCAT' function which gets close to what I'm after but I need some kind of seperators to make this work for me, otherwise the number merge!
Can anyone help?

Listed number data in cells on first tab.		Listed numbers referenced into single cell on second tab. (This is what I'm after)
45		45,56,78,90
56
78
90

Thank you.

Paul

 

[Fluff]

You need to use Textjoin rather than concat.