Transpose Data from Multiple Column to Single Column

[smudger1989]

Hi All,

Could do with some help with this...

I need to collate data from 3 columns to a single column.

Please see the attached example: data from cells C4:E4 sheet 1 need to be collated to a single column as shown in C3 sheet 2.

Any help would be appreciated.

Cheers.

[AndyLitch]

This worksheet formula should do it

=Sheet1!C4 & " " & Sheet1!D4 & " " & Sheet1!E4