Reformat Report "Excel" Layout

[mikes4x4@mac.com]

I'm an Excel novice and need to know if what I describe below is possible and reference to where I can learn to reformat report "Excel" layout.

THE PROBLEM:
My business uses an Inventory program, WASP, the reports it generates can be output as an Excel or as a Tab Delimited file. The problem is the reports which contains hundreds of line items with numerous sizes for each item formats vertically only. To review the entire printed report dozens of pages containing just a few columns are printed.

I prefer to list the Items and there numerous sizes horizontally in columns, this format is much easier to read and requires less pages.

MY QUESTION:
Is it possible to automatically reformat the layout from vertically to horizontally as described above from an Excel or Tab Delimited file?

Where may I find a tutorial to reformat layout?


Thank You,

[ChemistB]

Depending on any patterns in the data format, it can probably be done with VBA or with formula's. Can you give an example of how the data would be exported? Is it all in a single column? Are there single blank rows between records? Is it always the same number of rows per record?

[mikes4x4@mac.com]

The Data is exported from WASP Inventory program as a CSV File and opened in Excel, see attached file "WASP Inventory Report". It list all inventory items vertically and includes several columns of information we do not need for the purpose of reviewing inventory.

Attached is a sample of the "Master Inventory Report".

Master Inventory Review.xlsWASP Inventory Report.xls

I need to know if it's possible to easily convert the format of the Wasp Inventory Report to the format of the Master Inventory Report.

Also, from time to time we add new inventory items which will ripple the inventory list. When you say "Formulas" I assume you mean a workbook worksheet
that equals the value from another worksheet? I'll need to read up on VBA? Please point me to tutorial or instructions.

Thank you for your time.

[JBeaucaire]

Are the header in D:BK going to already exist?
Do those ever change?
Is that the whole list so if it needs to be added by macro we can simply replicate those headers as shown?
That's all the "sizes" ever needed?


In the CSV "item description" column, the sizes are always the last single word?

The Master has hidden columns all through it, necessary?

[mikes4x4@mac.com]

Are the header in D:BK going to already exist?
I'll assume the D:BK headers refer to the WASP Inventory Report? Yes those are the headers and WASP does not provide for filtering what categories are reported.

Do those ever change?
NO, unless WASP reprograms the report functions.

Is that the whole list so if it needs to be added by macro we can simply replicate those headers as shown?
Yes

That's all the "sizes" ever needed?
Yes, unless he manufacturers add new sizes, for now the "Master Inventory" list all the sizes we carry.

In the CSV "item description" column, the sizes are always the last single word?
Yes.

The Master has hidden columns all through it, necessary?
Not absolutely necessary although it does make this report useful for other reports.


Thank you for your help, eventually I hope to convince WASP to expand the functionality of their reports, for now I need to figure out best way to reformat their reports.

[JBeaucaire]

Each time you get the CSV, would it replace ALL the data in the Master? Those hidden columns have data that are not in the CSV file (prices), so clearing the Master sheet and recreating it would not be replicating those prices.