Hello - Recently asked the following question for Excel (http://www.experts-exchange.com/Database/MS_Access/Q_28370854.html
). The Excel solution was to use Index and Match to create the additional columns ... which worked ... but thought it would probably be much easier to do in Access.
Basically have a Table with two fields (i.e. ABC and Remarks) and want a query to put all the A remarks together on one line, same with the B's and C's something like below.
A Remark2 A Remark1 Remark2 Remark3
A Remark3 to B Remark4 Remark5
B Remark4 C Remark6 Remark7 Remark8 Remark9
Would appreciate some assistance on what would be the best way to go? Thanks.