Solved SPECIAL TRANSPOSE DATA

[georg0307]

Dear All,

is a way to obtain the result from a starting table, what I am showing in the attached file?

EXAMPLE SIMPLE:

STARTING TABLE:
A 1 APPLE
A 5 ORANGE
B 2 TRUCKS
B 5 CARS

RESULT NEEDED:

A 1 APPLE 5 ORANGE
B 2 TRUCKS 5 CARS



It is a sort of transpose special.

Thanks in advance.

Georg

 

[Gasman]

I believe you would need to adapt one of these routines.

Microsoft Access tips: Concatenate values from related records

Return a string containing the values of related records.

allenbrowne.com

Code Snippets

If you read the last link, that actually explains what you need to do, so that would be the best option?

 

[arnelgp]

here i converted your xlsx to xlsm.
click on the "button" to transpose you data.
it will be transposed to TransposedData shet.

 

[Gasman]

here i converted your xlsx to xlsm.
click on the "button" to transpose you data.
it will be transposed to TransposedData shet.

Oops, never spotted it was in the Excel forum.
Sorry.

 

[georg0307]

here i converted your xlsx to xlsm.
click on the "button" to transpose you data.
it will be transposed to TransposedData shet.

Something really great thanks a lot!!!

here i converted your xlsx to xlsm.
click on the "button" to transpose you data.
it will be transposed to TransposedData shet.

PERFECT REALLY good -GREAT!!! Many thanks.