data transform??

A

arran1180

I have imported data that comes with headings:


AUD
01/02/06 data info
02/02/06 data info

USD
01/02/06 data info


the AUD heading occurs in the same column as the date. I am trying to
manipulate the data into something like this:
01/02/06 data info AUD
02/02/06 data info AUD
01/02/06 data info USD

the imported data has a autonumber as a primary key (ckey field)

any advice on how to do this greatly appreciated
thx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

frustrating input data!! 1
crosstab or pivottable or ? 1
macro to add numbers based on set criteria 6
Data Mining and Hyperlink Automation Macro Help 0
Macro for Drill Down and Hyperlink Automation 3
Macro for Drill Down Hyperlink Automation ? 1
Macro for drill down & hyperlink automation 0
Macro to filter two columns 8

Top