How to display 3 columns data in one cell

[Naagi]

Hi,

I have data
Sheet1:
id name
1 a
2 b
3 c

Sheet2:
id Place
1 d
2 e
3 f


I need output as

sheet3:
value coulmn1
Row1: 1 a d
Row2: 2 b e
Row3: 3 c f

All values should be in one cell.

Thanks in advance

 

[Vivek D]

See attached. I've just put everything in 1 sheet for simplicity but you can basically do the same across sheets as well.