Solved SPECIAL TRANSPOSE DATA (1 Viewer)

[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?

 

[Uncle Gizmo]

Not sure this fits the bill:-

Display Field Data Horizontally - Nifty Access

Transform, Concatenate Examples A common requirement in MS Access is to extract Columnar data into horizontal data, for instance to make reports look better, to provide a list of emails suitable to send to with Outlook. In the YouTube videos below I explain how this can be done. Display Field...

www.niftyaccess.com

If you want a free copy of the example, sent me a private message through this forum and I will send you a coupon code

 

[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.