How to add space between first name and last name

[mandilicious]

Hi Champs

Can someone help on how can I add space between First & last name in below example table?

I need to have space  like below

Brolin Helen

Callins Joan

Carsson Rob etc.

Thanks

[mandilicious]

Hi Sunny

I need to separate it like below

Month

JUL

OCT

JAN

APR

YEAR

2016

2015

Thanks

[sunny_talwar]

Try this

Table:

CrossTable(MonthYear, Data)

LOAD Country,

    " [Jul-Sep 2015]",

    "    [May-Aug 2015]",

    "    [Oct-Dec 2015]",

    "    [Jan-Mar 2016]"

FROM

[..\..\Downloads\Exp (1).xlsx]

(ooxml, embedded labels, table is Sheet1);

NewTable:

LOAD *,

Date(MakeDate(Year, Month)) as MonthYear;

LOAD Country,

Month(Date#(Left(Trim(PurgeChar(MonthYear, ']['&Chr(160))), 3), 'MMM')) as Month,

Year(Date#(Right(Trim(PurgeChar(MonthYear, ']['&Chr(160))), 4), 'YYYY')) as Year,

Data

Resident Table;

DROP Table Table;

[mandilicious]

Thank you very much Sunny you are the best:)