Hi there,
I am new on this forum, and I hope I could find the help I need on my excel issue.
Here is the background:
I need to create a CSV file where all data have to be displayed in 4 columns: A=Product / B=Geography / C=Account / D=Data.
My source file has 3 different dimensions, 2 dimensions are already displayed in columns (Product / Account) and 1 dimension is displayed in a row (Geography).
My question is this one: how can I tell Excel to create a CSV file when I have dimensions and data differently displayed in my source file? Is there a mean that I can use to simplify the creation of a CSV, by doing some formulas/macros?
Actually, the only solution I have found is the useof an Offset formula for the column creation in the CSV and the use of an Array formula (Sumproduct) for the data input in the CSV. However, when I used my methodology, I came up with a huge file and the number of rows in the CSV is up 65K. Would you know a good solution here to reduce the amount of rows, and to automatise the calculation process?
Please note that I am not at all familiar with Macros - but I am wondering if the use of Macros would be a good option here...?
See below an example of how the data are displayed in my different files (Source File and CSV file)
database example.jpg
I use MS Excel 2007, ASAP utilities on Windows XP
Any help would be highly appriciated!
Many thanks,
PowerExcel
Bookmarks