Cross table

JabazanJabazan Member Posts: 2 Newbie
Hello, I am trying to get the information of several Excel files in a folder. 
Each file has the following format:

 Date store1 store2 store3
dd/mm/yyyy  $ #.00(sales)  etc

I would like to crosstable this formato to obtain this one:

Date store_id Sales
dd/mm/yy store1 $ xxxx

I will appreciate your guide to get an answer.
Best regards 

Best Answer


Sign In or Register to comment.