Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
If you use CrossTable load you won't have to worry about incrementing a month every month. Which solution are you going with?
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
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?
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.
Let me spend some time and get back to you