Help converting rows to columns

  • Thread starter Thread starter Cowdog Gal
  • Start date Start date
C

Cowdog Gal

Hi,
I need a query that will convert rows to columns where
the first values are equal. The data I have is like:

Column 1 Column2
A Value 1
A Value 2
B Value 3
B Value 4
B Value 5

I want to convert that to:

Column 1 Column 2 Column 3 Column 4
A Value 1 Value 2
B Value 3 Value 4 Value 5

There will never be any letter for which there are more
than 3 values. Please help if you can.

Thanks!
 
TRANSFORM Min(tblCowdog.Column2) AS MinOfColumn2
SELECT tblCowdog.Column1
FROM tblCowdog
GROUP BY tblCowdog.Column1
PIVOT "Column " & DCount("Column1","tblCowDog","Column2 <='" & [Column2] &
"' AND Column1 = '" & [Column1] & "'")+1;
 
Amazing! You're awesome, Duane!!!! It works perfectly.
Thank you so much for your prompt, and helpful input.

-----Original Message-----
TRANSFORM Min(tblCowdog.Column2) AS MinOfColumn2
SELECT tblCowdog.Column1
FROM tblCowdog
GROUP BY tblCowdog.Column1
PIVOT "Column " & DCount("Column1","tblCowDog","Column2 <='" & [Column2] &
"' AND Column1 = '" & [Column1] & "'")+1;

--
Duane Hookom
MS Access MVP


Hi,
I need a query that will convert rows to columns where
the first values are equal. The data I have is like:

Column 1 Column2
A Value 1
A Value 2
B Value 3
B Value 4
B Value 5

I want to convert that to:

Column 1 Column 2 Column 3 Column 4
A Value 1 Value 2
B Value 3 Value 4 Value 5

There will never be any letter for which there are more
than 3 values. Please help if you can.

Thanks!
Click to expand...


.
Click to expand...
 
It might be slow but it works.

--
Duane Hookom
MS Access MVP


Amazing! You're awesome, Duane!!!! It works perfectly.
Thank you so much for your prompt, and helpful input.

-----Original Message-----
TRANSFORM Min(tblCowdog.Column2) AS MinOfColumn2
SELECT tblCowdog.Column1
FROM tblCowdog
GROUP BY tblCowdog.Column1
PIVOT "Column " & DCount("Column1","tblCowDog","Column2 <='" & [Column2] &
"' AND Column1 = '" & [Column1] & "'")+1;

--
Duane Hookom
MS Access MVP


Hi,
I need a query that will convert rows to columns where
the first values are equal. The data I have is like:

Column 1 Column2
A Value 1
A Value 2
B Value 3
B Value 4
B Value 5

I want to convert that to:

Column 1 Column 2 Column 3 Column 4
A Value 1 Value 2
B Value 3 Value 4 Value 5

There will never be any letter for which there are more
than 3 values. Please help if you can.

Thanks!
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top