Unanswered: Convert multiple rows to one single row data
I have data which is in multiple rows and I want the data in these rows to be joined together based on a condition.
SKU Description Value
1 abc 123
1 bcd 23
1 cde 45
2 xyz 66
2 fgh 20
3 lmn 10
Oog. There is a quirk in SQL Server which allows you to do this, but I doubt that it would work in Access. This is generally not a good idea to do at all, but their may be a method that will work for you.
Can you place an upper limit on the number of values that would be concatenated for each row? Say a maximum of five or six?
If it's not practically useful, then it's practically useless.