Member Avatar for marellow
marellow 0 Newbie Poster

Hi everyone,

I would like to transpose the data from queries in access database,

the current data extracted from the table look like this :

From table:
ID Year Value
AA 1 100
AA 2 101
AA 3 200
BB 1 125
BB 2 150

I would like to transpose the data into :

ID Year1 Year2 Year3
AA 100 101 200
BB 125 150

can anyone help me to figure out this thing ?

thanks in advance

  • 1 Contributor
  • 0 Replies
  • 42 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.