Code to transform layout of existing data

[Guest]

Hello,


I currently have a table filled with data from an access query that is in the following layout:

AP S-P WP DWG# DWGI Commit RfR
********************************************



I need to create a code that will cycle through all of these entries found in sheet1 and make a new layout like:


AP S-P WP DWG# A03 A02 A01 A00 Commit RfR
********************************************************



I need to sort thhrough the DWGI to seperate them in seperate columns. This way there is only row per DWG# and multiple columns depending on the maximum DWGI

Thank you for the help,

Daniel

 

[Tom Ogilvy]

This could probably be accomplished fairly easily with a pivot table (under
the data menu). I assume at least some of columns are numbers? Even if
not, you might be able to use it to build the initial table, then use the
results to build the table in the exact column order you want.

Hello,


I currently have a table filled with data from an access query that is in the following layout:

AP S-P WP DWG# DWGI Commit RfR
********************************************



I need to create a code that will cycle through all of these entries found

in sheet1 and make a new layout like:

AP S-P WP DWG# A03 A02 A01 A00 Commit RfR
********************************************************



I need to sort thhrough the DWGI to seperate them in seperate columns.

This way there is only row per DWG# and multiple columns depending on the
maximum DWGI