Month Year field

[prma7799]

Hi All,

I have multiple fields like below

SALES UNIT JAN-10

SALES UNIT FEB-10

SALES UNIT MAR-10

SALES UNIT APR-10

I want output like below

Apr-10

May-10

Jun-10

Jul-10

[sunny_talwar]

If you use CrossTable load you won't have to worry about incrementing a month every month. Which solution are you going with?

[prma7799]

Hello  sunindia‌,

I am going with Cross table load.

But there is one problem I have big size excel sheet and it has to many column.

PFA ...

In that sales unite and sales values are there and both values are different for every months.

in that i dont want  coloumn which is in red color.

Thanks

[sunny_talwar]

This complicates things little bit. So what happens when you have new data for a month? You insert new column in between to add a new row?

[prma7799]

See the attached

First i have to load this excel for Sales Unit in yellow colour means column A to DA

Secondly again i have load this excel for Sales Value in green colour means Column A to GS but exclude column AH to DA which for Sale Unit.

So my question is how to upload this file with cross table load at one time column A to AG is which is in blue same for Sales Unit n Sales Value.

In that I don’t want column DB to DY n GT to HQ which is in Red.

[sunny_talwar]

Let me spend some time and get back to you

[prma7799]

Hi sunindia‌

Any Update on this?

Thanks