How to get?

[subbareddykm]

Hi all,

I want to how to get below data, in correct format.

For example let us assume low code.

Load * Inline [

Name1 , Sales,Bug

A,20,92

B,28,22

C,76,83

,

,

City,-,92

KA ,78,92

MUM,33,25

Hyd,82,49

];

what i want is In name1 A B C along with sales and budget

For City also same.

If i do cross table i m not getting out put.

CAn any one tell me how to do this?

[Siva_Sankar]

Subbareddyy,

You can use concat function to do that. For example, refer here Combine Multiple Cell Values into One and

Combine Multiple Cell Values into One

How to Concatenate several rows into one field by a dimension