Crosstable question

[#1]

Hi there

I have an excel file with several colums for different categories of information repeated for a certain number of years.

For exemple

ID - PRODUCT - CAT_A_Y04 - CAT_A_Y05 - CAT_A_Y06 - CAT_B_Y04 - CAT_B_Y05 - CAT_B_Y06

and so on.

I'd like to obtain something like:

ID - PRODUCT - YEAR - CAT_A - CAT_B

How should I do?

Thanks

-g

[Anonymous]

g,
Because you have two sets of fields - A, and B - you can use two consequent crosstable loads. First time only A-fileds, second, only B-fields. After that, join into one table if needed.
Maybe there is a better way that I don't know yet...

[#3]

Hi,

Here you go.... !

See the attachment.

Please let me know if it works

Cheers

- Sridhar

[#4 · Accepted solution]

Hi,

Sry, There was some error in my previously posted application.

No, here is the working version.

- Sridhar

[#5]

Hi Sridhar I have tested with a new set of colums and all wen fine.

searching around in the forum I found a piece of the code you used to trasnform the cross table as I wonted.

Thanks a lot for your help.

- giulio

[#6]

Dear , Please share how did you do? Thanks

[#7]

in the answer gave me by Sridhar you can download the file answering my question.