Hi, I have a list of umpteen different people, each has a row record against different columns, I want to 'convert so that the column data appears in a single row for each.
I might in VBA territory, I'm not skilled there, advice welcome please.
Thanks in advance
Is data layout correct (i.e. person A has to 'No' in data column 2) how and what does this event represent ?
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Hi Peter,
like this, please see attachment?
br, Alexandra
I am surmising that "No" qualifies as "data". Please see the attached.
To get unique people this formula in column Lthen this one in M2 and copied down.Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Dave
Maybe this, with the headers collated:
PHP Code:=LET(a,A2:A26,ua,UNIQUE(a),f,BYROW(a,LAMBDA(a,FILTER($C$1:$J$1,INDEX(C:C,ROW(a)):INDEX(J:J,ROW(a))="No"))),hs,HSTACK(a,f),brtj,BYROW(ua,LAMBDA(ua,TEXTJOIN(", ",,FILTER(INDEX(hs,,2),INDEX(hs,,1)=ua)))),HSTACK(ua,brtj))
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks