Creating One Two Column List from a Multiple Columned Table

[Tranquilo]

I currently have three very large spreadsheets to import into Access. Unfortunately, the database I'm using requires two columns to work. Currently the table looks as follows:

SKU1 | SKU2 | SKU3
Store # (Quantity) | (Quantity) | (Quantitiy)


What I would like to do is combine all combinations of the store# with the column number and the matching cell:

Store # * SKU (Quantity)

Is there a way to do this without having to reenter everything or coming up with something in VB?

Thanks

 

[SkipVought]

Hi,

Just some basic data manipulation techniques will work like a charm for a ONE TIME fix...

1. take your basic table and copy the store# data and past it below the laste store#

2. copy the sku2 data and past it next to the column you just created

3. repeat 1 & 2 for sku3

4. delete columns for sku2 & sku3

VOLA!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com